on 01 Sep 2016 22:17:00
The current version of the data source browser in PBI desktop only seems to support a limited numer of objects. Only the first 10.000 objects are shown in the list - and it becomes sloooow.
If the desired object is not under the first 10.000, you are lost. The search won't work. Your only option is to write a query in the SQL field. But because there is no option to Name your data source, you can only do this once - another query on the same source will overwrite the data source. I experienced that with an Oracle DB, so perhaps the issue is source specific.
- Comments (15)
RE: Support databases with >10000 objects
10,000+ items within a single schema for an ERP solution such as Oracle is the norm and not the exception. The filter only works at the schema level and not the entities within the schema.
RE: Support databases with >10000 objects
I have + 10,000 items within a single schema. What to do then ?
RE: Support databases with >10000 objects
Microsoft Dynamics NAV 2017 does create a table for each company in the database, thus you may have many more han 10,000 tables and no way to reach them by the explorer.
RE: Support databases with >10000 objects
I get complaints from users about this. Those users want to query SAP BW tables on the database directly (don't ask). In this case, they've got around 60.000 objects in a single schema and the hierarchical navigation doesn't help. the major complaint is about the fact, that Power BI doesn't show a message that a limit is reached - for them Power BI simply can't find the desired tables - a bad start for new users. I thought about a workaround that involves a user with permissions on only a subset of tables - not good to explain that to the SAP Basis guys... I agree that noone ever will scroll though 60k tables, but I'd expect the search to work on the whole set of tables and not only on the first 10000.
RE: Support databases with >10000 objects
Thanks for your feedback - note that, as a mitigation for this issue, you can enable Hierarchical Navigation from the connector dialog (i.e. From Oracle), which will group the navigator tables by schema. Generally, you won't have 10,000+ items within a single schema.