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...
  • 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