Forum Discussion
Power BI load from SQL Server extremely slow
Hi Anonymous ,
A common way to optimize data loading speed in general is to use the two methods mentioned above: "transform first, then load" and using query statements to extract specific data. Other methods, as far as I know, are related to the network environment, the speed of the computer itself and other hard settings. I am not aware of any settings to make the data faster as you said, maybe you can suggest your ideas in this link:Ideas (powerbi.com).
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi there. Thank you for your reply, Of course, I know I can do transformations, which I have already done to reduce the size significantly. I was mainly wondering if I can do anything to improve performance other than that, and in general what the Power BI limitations are.
Hi Anonymous ,
The main factors affecting power bi performance are these：
related link:
Optimization guide for Power BI - Power BI | Microsoft Docs
You can optimize these to improve performance.
If you are dealing with reports or visualization processes, you can refer to this link to find out the reasons for the impact：Monitor report performance in Power BI - Power BI | Microsoft Docs
You also mentioned that you want to know the limitations of power bi, I don't know what you want to know, if you just mean the performance, the above document you can learn more about.
If it's something else you can tell me what other limitations you want to know.
Best regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly .
Hi selinaz,
Appreciate your reply, but maybe I wasn't clear in my question. This was more a "tips and tricks" question specific to SQL Server or other traditional DBs. It was not a general performance question, of which I am familar with general performance techniques. Again, I appreciate the reply, and sorry for the confusion.
Hi Anonymous ,
You can write specific SQL statements to get specific data you want to import into power bi desktop when connecting to the data source, which not only reduces useless data, but also reduces the amount of data to improve the import speed.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
hey mengzhu, thanks for the reply, but again, this does not solve my issue
The data set is already as small as it can be. The question is simply whether or not there is a trick to load the data faster. That's it. If there is no solution, that's fine, but that was the question.