cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
T_Findeisen
Level: Powered On

PowerApps SLQ server with 500+ tables

Hello everybody,

 

I am trying to create an App accessing the table dbo.SalesTable in Dynamics 365.

When I try to connect to this table the listed tables in the DB stop in the 'R*' name range, I suspect because of the 500 record limit.

What I have tried so far without success:

Listing the tables in a descending order -> it starts with the last R-table

Using the provided search field -> only lists results within 500 range

writing '[dbo].[SALESTABLE]' in the function field -> returns invalid name

raising the limit in the experimental features -> no changes

using ' && Search(dbo, 'salestable')' instead of SALESTABLE is not working either.

 

Is there a different way to specify or connect to a table that is outside of the 500 result limit?

 

Best regards

1 REPLY 1
Super User
Super User

Re: PowerApps SLQ server with 500+ tables

Unfortunately, you appear to have encountered a bug in PowerApps that prevents us from accessing databases with large numbers of tables. There are more details here.

https://powerusers.microsoft.com/t5/General-Discussion/Bug-limited-number-of-tables-accessible-from-...


One way to work around this problem is to create a new user in SQL server and to grant access to a subset of the tables that you want to access in your app, which will include your [dbo].[SalesTable] table. You should not grant access to more than the approximate limit of around 1600 tables.

If you then connect to your database under the context of this new user, you should be able to access your [dbo].[SalesTable] table.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,584)