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 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.
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
got it thank you