All tables from the sql database not showing

Hi all,

I have the same problem with the production sql db of a client of mine. Navigator pulls in 10000 tables and stops. Filter on Names does not load more tables, so a couple of tables can not be reached out to. Even more weird, in the development db, it only pulls in ~4600 tables, which makes me think that there is some kind of time out for the Navigator Window. Any ideas, if there is a setting for this or how to get around this? Thx in advance!

jakmar you mean under navigator window. i don't think there is option currently to change the way navigator window works.

Hello. 

I am having this issue when getting data from MS SQL. Did you find a way to see all tables?

Thank you,

Maria 

Hello, 

please find the workaround for the above issue.

1. connect to database in power bi desktop.

2. select any table which appears at the top of the list.

3.click on transform data and change the schema and table name in the M query sections as shown below.

4. change the name of the table to required table name.

Thanks and Regards,

Anil Subray Mesta