Forum Discussion
All tables from the sql database not showing
When we do the direct query or import to our sql datasource all of the tables are not listed. I notice that there is a counter that stops at 10000 every time that we do the connection. Is there a way...
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