Forum Discussion

Larsc's avatar
Larsc
Frequent Visitor
3 years ago

SQL Data Source - Does not show all tables

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?

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • Larsc's avatar
    Larsc
    Frequent Visitor
    3 years ago

    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.