Forum Discussion
Data view not working with large SQL server datasources
Hi Anonymous ,
If I understand your issue correctly that you have the problems when import data from SQL Server Database with large dataset.
I have not had this problems before in power bi. If it is convenient, could you share the screeshots about this issue.
Besides, do you have this issue everytime when import the data source?
In addition, if your data source is very large, I'm afraid that use direct query mode will be better.
Will you have this issue for direct query?
Best Regards,
Cherry
Hi,
How many row and column for my solution i analyst and plan a model and shap data for using it only because if your load all data and don't use Query may have low performance in the next feauture and let use see post link as below for information :
https://community.powerbi.com/t5/Service/Limitation-of-data-size-in-the-Service/td-p/344970
