Forum Discussion
Loading Data more than 10,000 tables
Hi,
Why PowerBi Desktop loads only 10,000 tables when imported from SQL Server. Is there any way to load the whole dataset?
Thanks in Advance.
9 Replies
Hi Keerthika ,
Do you have any error message? If you have, could you share the error message screenshot.
By my research, there is no official document points out the maximum number of rows imported to Power BI desktop.
In addition, there is 1 GB limit which is for the data model within a pbix.file, but there is no restriction on how large a pbix file can be locally.
However, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message. And in the case that your pbix file is less than 1GB when importing it to Power BI service, but the data model grows beyond 1 GB after a period of time, you will get a message when refreshing the dataset.
For your scenario, you could try with Direct query mode.
Best Regards,
Cherry
Hi v-piga-msft
Thanks for those points. I do not get any error message, but the loading stops at 10,000. I couldnt view more than that.
And also is there any way to load only tables without views and procedures?
Thanks.Hi Keerthika ,
I have a little confused about your question.
Actually, we need to select the tables in the Navigator or you could select all tables with SQL Statement under Advanced options.
If you don't want to load the views, you could not select the views in the navigator.
If you need other help, please share some screenshots to describe your scenario better.
Best Regards,
Cherry
