When I connect to SQL Server on premises using On-premises data gateway, only the first (alphabeticaly) 25 tables are shown. My table name is Logbog (27), and it is not shown in the tables list.
How can I connect to a table, which is down in the list (>25)?
Solved! Go to Solution.
Hi Yakimo,
About this issue, I tested it on my side. I have 28 tables on my SQL Server database.
Then I created a connection from PowerApps to SQL Server On-premise through Gateway, I can see all my 28 tables on the “Choose a table” list.
Please try again with this issue, I guess it has been fixed now.
If you are still getting the issue, please feel free reply.
Best regards,
Mabel Mao
Well, I posted my message with the observed problem Friday, @Meneghino confirmed the problem.
And during the weekend - it was good again - probably the Powerapps team had fixed it. Thank you, team 🙂
It will be great if the other errors (that are showstoppers for me, like filtering more than 500 records for example, or displaying images from a sharepoint list) get fixed soon.
But it seems I am not so lucky with that - can see the error for filtering was reported first time long time ago and it must be 'known issue' for the team. But it is still there - and no workaround.
I would say that 500 records is "almost nothing" - and this is a huge problem for us
Hope somebody will hera our voices
Thanks
Yakimo
I confirm I have the same problem:
Hi Yakimo,
About this issue, I tested it on my side. I have 28 tables on my SQL Server database.
Then I created a connection from PowerApps to SQL Server On-premise through Gateway, I can see all my 28 tables on the “Choose a table” list.
Please try again with this issue, I guess it has been fixed now.
If you are still getting the issue, please feel free reply.
Best regards,
Mabel Mao
Well, I posted my message with the observed problem Friday, @Meneghino confirmed the problem.
And during the weekend - it was good again - probably the Powerapps team had fixed it. Thank you, team 🙂
It will be great if the other errors (that are showstoppers for me, like filtering more than 500 records for example, or displaying images from a sharepoint list) get fixed soon.
But it seems I am not so lucky with that - can see the error for filtering was reported first time long time ago and it must be 'known issue' for the team. But it is still there - and no workaround.
I would say that 500 records is "almost nothing" - and this is a huge problem for us
Hope somebody will hera our voices
Thanks
Yakimo
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
207 | |
187 | |
83 | |
52 | |
37 |
User | Count |
---|---|
288 | |
245 | |
119 | |
78 | |
56 |