Forum Discussion

jillian's avatar
jillian
Advocate II
10 years ago
Solved

Power BI Desktop Refresh Slow

I just upgraded to the latest Power BI Desktop Version: 2.32.4307.522 64-bit (February 2016).   Since the upgrade, when i attempt to Refresh the data from SQL Server, the application loads the rows...
  • pqian's avatar
    pqian
    10 years ago

    jillian, one other thing to turn off (just to diagnose) in the settings dialog:

    Current File->Data Load->Auto Date/Time

     

    With this off, try refresh again

pqian's avatar
pqian
Microsoft Employee
10 years ago

jillian are the numbers for any of these queries moving?

 

If you go to the Task Manager, how many Microsoft.Mashup.Container*.exe can you find there, and are any of them busy?

Have you tried to disable relationship detection in the settings dialog?

jillian's avatar
jillian
Advocate II
10 years ago

The data changes once per hour for this particular dataset. The entire .pbix is only 3.8MB including the data. I'm currently seeing 3x Microsoft.Mashup.Container.NetFX40.exe's running.

 

I tried disabling both Import / Autodetect Relationships as well as disabling Type Detection. I'm seeing the same slowness on this latest build.

 

-jillian