all my tables are not loading when I connect to the database

[jwlakd]

I am just starting with power BI desktop and working to use it as a solution for our reporting needs.

When I connect to the database I am not getting all my tables in the database.  We have more than 10000 tables. 

How do I access the rest of my tables in the database

[Uzi2019]

Hi @jwlakd 
Try to load few tables at a time. I guess power bi has limited capacity of data storage.
check this.

The Power BI file size can't be bigger than 1 GB. You will get an error If the file size is bigger than 1 GB, in this case, you must have the Power BI Premium that allows having 50 GB file size.

You can also check other blogs for better understanding:
https://community.fabric.microsoft.com/t5/Desktop/Data-size-and-limitations/m-p/752170

I hope i answered your question!