Limit Number of Tables in Import List

[schatzl]

Hello everybody 😉

Im a newby in Power BI Desktop and did connect our MS SQL DB sucessfully to Power BI.

Now i cant find some tables in the generated "table, view and functions" listing (counted up to 10k and exit).

The same result, when i use the search-function.

So i looked for the reason - it seems it is the 10k tables limit - and also found nearly the same in a message from another user here:

https://community.powerbi.com/t5/Desktop/Limit-Number-of-Tables-in-Import-List-from-Oracle-Database/...

It is marked as solved, but the problem exists "without additional query" and i would prefer to set limitation-value from 10,000 to 12,000 viewed tables/views. (Or to find with "search" the expected table.)

Is there any way in PBI-Desktop - Who knows?

Thanks in advance for your help!

Best regards

Dominik 

[AbdulQayyum]

This properly worked for me
1) Select any of the report and load it in power bi.

2) open advanced editor and change the highlited numbers with your salesforce report number

3) to find your sales force report number open your report in sales force

4) And see the link https://teradata.lightning.force.com/lightning/r/Report/00O6R000007rw1pUAA/view
This is my first solution on this platform please like or mark this as solution 

[FrankAT]

Hi @schatzl 

it's limited but you can use the search field to get the table or column name:

Regards FrankAT

[amitchandak]

@schatzl , while adding tables, you can type a few letters and it brings tables filtered based on that

[schatzl]

Thanks for your answers @FrankAT & @amitchandak  but sorry this doesn't solve my problem.

The listed entries (count up to 10,000) in Navigator where created before you can input something in search and only these filtered tables, views and functions will be included in search. So i can't find the missing table in search, the tables i'm looking for are at the end of the database and not in the selection of Navigator!

Differently to the other user who solved the problem in deleting "Recycling-waste" my tables are not waste and can't be deleted (bad guys didn't use schemas on db architecture and store many different mandants in one big DB 😞 )

So i'm looking for any solution to view or select more than 10k entries in the Navigators list (is there no way in an config-file or sth. to set the value bigger than 10k)??

Kind regards

[amitchandak]

@schatzl , need to check for an option. The way to check your table as of now. In the advance option of connection give a query to select from that table 

[schatzl]

@amitchandak , thank you again.

This is also my workaround at the moment, but it is not always easy to know all tables before you generate/design a BI dashboard/report. I can't add tables/views easy at the moment (same problem) and so i have to know all the needs before to write a good working query for each dashboard/report.

Is the limitation hardcoded or is anyone knowing where the 10k-setting can be changed?

[v-xicai · Accepted solution]

Hi @schatzl ,

It is not supported to set the limit number of importing tables in Power BI currently . There is an idea about this issue, please vote it up, Support databases with >10000 objects  ,  add your comments there to improve Power BI and make this feature coming sooner.

As a workaround, you may specify SQL statement in the Advanced option of connection page .

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.