Slow dataset refresh from dataverse

[jja]

Hi

When i shedule refresh from dataverse it takes to refresh 18 minutes.

If i hit refresh on desktop it takes 20 seconds.

There is almost no data in dataverse.

Why is it so slow?

[jja]

@Anonymous 

I tried something different. I disabled sheduled refresh and create power automate flow to that that. It takes now 10x faster.

Means the sheduled refresh service has some issues or is doing some strange tasks in the bcakground.

My refreshes started to run like >40 min and with the last powerautomate refresh i managed to do that in less then 2 minutes

[jja]

@Anonymous 

I read those articles but for me it is a mystery this case:

I login to powerbi service and hit the manual refresh - it is also a matter of seconds. 

When the sheduled refresh hits - it is 15-18 minutes.

How technically it makes this difference?

[Anonymous]

Hi  @jja ,

This is the related document, you can view this content:

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Powerapps-slow-to-refresh-dataverse-connecti...

https://community.powerbi.com/t5/Desktop/Connection-to-dataverse-extremely-slow/td-p/1781593

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Importing-data-via-dataflow-into-Dataverse-i...

Best Regards,

Liu Yang

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