cancel
Showing results for 
Search instead for 
Did you mean: 

Dataflow refresh very slow

yesterday and today im experience Dataflow refresh very slow, it takes already a couple of minutes, normaly it takes a ferw secounds. is there any outage today ??

 

aleksandrama_0-1644914227272.png

 

loading the table in Dataflow is also very slow, it takes 1,5 minutes 

 

Status: Investigating

Hi  all,

 

Please check whether the data amount refreshed quite large so it caused the long time refresh. If your model is very simple, please try to refresh your dataflow with on-demand refresh to see whether you will have same issue or whether this issue is happening at a relative fixed time.

If your dataflow refresh issue is not caused the above reasons and you are a Pro user, please consider getting direct help from the technical team of Microsoft by support ticket. They will have a remote session with you to troubleshoot on this issue.

For how to create a support ticket, please refer to this blog: https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Power BI Support: https://powerbi.microsoft.com/en-us/support/

 

It couldn't be better if any of you post the root cause and solution of such issue here once you get them from technical team to help others who may encounter similar issue. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

Comments
Marga93
New Member

Hello, I experience same issue since this morning. The flows are loading endlessly with no result.

Even a cancellation of the flow is not helping- it also gets stuck.

kapinal
New Member

Hey, when you using dataflows, a lot of transformations because using shared capacity it is sharing the memory and CPU. Whilst when you do this on desktop you got dedicated CPU and memory. If there is no issue with it taking longer to refresh I would then leave it as is, yes it is taking longer but there is no impact to the reports.

By the way If you are facing more issues in Power BI, You can reach us - https://www.dynamicssquare.co.uk/

Marga93
New Member

In my case, it's not a long load. It's stuck at loading. The refresh has no end. Tested from different accounts

kapinal
New Member

Hi contact Dynamics Square: 

https://www.dynamicssquare.co.uk/  for UK

 

https://www.dynamicssquare.com/  for USa

StNi
Frequent Visitor

Same problem with degraded performance here since this morning. Trying to author a new dataflow and filtering the sharepoint folder now takes 11 minutes and still counting...

GirlPowerBI
Frequent Visitor

In the Netherlands we experience the same problem, all dataflows have timed out after a two hour run. Has nothing to do with memory or CPU, since yesterday everything ran smoothly and today all of a sudden not so much. 

Ferrus
Advocate II

Same problem in France since this morning (Re: PBI SERVICE: Dataflow refresh very slow and im... - Microsoft Power BI Community

Any news about that issue? 

 

 

rjhale
Helper IV

Seeing the same thing in the US (Midwest).  Even loading tables with less than a 100 rows from a database is now taking up to 5 minutes to render in a Dataflow.  I've been seeing the same service degradation all morning. 

altbra
Frequent Visitor

Same in North Europe. And no respose from MS. 

anselmojg
Advocate I

Struggling with the same issue for a few days/weeks now... Today, it is specially slow ...

Refreshes of existing dataflows (premium capacity) going smooth but the editing experience to create/change existing dataflows is becoming IMPOSSIBLE....