SQL Data Source - Does not show all tables

[Larsc]

Hi

I am trying to get data from our AzureSQL server. It works fine, but I have discovered that the navigator does not list all tables that are in the SQL server. It only goes to S, and all other tables are therefor not shown, and as a result, I cant import the data.

But, as you can see directly from the SQL server, there are way more tables? How can I get Power Bi to show all tables?

[Larsc]

It seems like there is a maximum number af tables PowerBI kan show. The cap seems to be 10k tables.

Our DB contained far more then 10k tables, and therefor Powerbi doesn't show all tables.

[v-rzhou-msft]

Hi @Larsc ,

I think you are trying to get data from Azure SQL Server by import connection mode. Here I will give you some suggestions.

1. You can try Direct Query connection mode to get data.

2. You can try to change Timeout minute or use SQL statement to get the table you want in Advanced options.

Best Regards,
Rico Zhou

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