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 (12)
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.