Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI load from SQL Server extremely slow

Hi all,   I am trying to load a SQL Server table which is ~45M rows (no transformations, just a table load), but it's slow to the point of unusable. Does anyone have experience dealing with this? I...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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 

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , I have loaded and it takes time. So I have setup incremental to load only limited data in power bi desktop and rest load in power bi service.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thank you for your reply, but I don't understand completely. Do you mean you have a separate test data source, or you import a limited set from the main data source, then publish and the rest is loaded? If the latter, can you expand a little on how you do this?