cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI Desktop is very slow when refresh or edit

For some time now I am having an issue that queries in Power BI Desktop are very slow.

Especially when I refresh them or do modeling.

At the same time the very same queries will only take seconds to refersh or edit in Excel.

 

So at last today I figured out that it was Windows Defender antivirus causing the issue.

I excluded some paths and processes from scanning and I am back to seconds instead of minutes delays.

 

I recommend excluding the folling item from your antivirus.

If you have anything to add to this list, please share.

 

Hope this helps.

 

P.S. and Power BI team could really have an arcticle about it, or something.

------------------------------------------------------------

Files and Folders:

 

  • %UserProfile%\Microsoft\Power BI Desktop Store App\Cache\*.dat
  • %UserProfile%\Microsoft\Power BI Desktop Store App\Cache\Index\*.idx

Extensions:

  • pbix
  • idx

Processes:

  • %ProgramFiles%\WindowsApps\Microsoft.MicrosoftPowerBIDesktop*\bin\PBIDesktop.exe
  • %ProgramFiles%\WindowsApps\Microsoft.MicrosoftPowerBIDesktop*\bin\msmdsrv.exe
  • %ProgramFiles%\WindowsApps\Microsoft.MicrosoftPowerBIDesktop*\bin\Microsoft.Mashup.Container.NetFX40.exe
  • %ProgramFiles%\WindowsApps\Microsoft.MicrosoftPowerBIDesktop*\bin\Microsoft.Mashup.Container.NetFX45.exe
  • %ProgramFiles%\WindowsApps\Microsoft.MicrosoftPowerBIDesktop*\bin\CefSharp.BrowserSubprocess.exe
Status: New
Comments
Moderator

Hi @jevgenijmart,

 

Please create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,

Qiuyun Yu