Dashboard Refresh slowness

[MR007]

Hi Team,

i am facing issues while refreshing dashboard it is taking so much time to connect IDP,

is there any workaround reslove this also it is taking so much time to scheduled refresh on Services.

Thanks in advance.

[V-lianl-msft · Accepted solution]

Hi @MR007 ,

When you do joins/appends in Power Query it has to load the entire table into virtual memory. This causes a lot of paging and is very slow.

The performance will involve many aspects, you could refer to below documents and blogs that may help you:

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization 

https://www.sqlbi.com/topics/optimization/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.