The refresh operation failed because it took more than 120 minutes to complete.

[ezarebska]

Hi Colleagues,
I have a data set that is fed by data from a web API endpoint. Since few days refresh from PowerBI service started to fail because of:
 
The refresh operation failed because it took more than 120 minutes to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets.

The same issue occurs for scheduled refresh and for demand. After downloading .pbix refresh worked locally, so I suppose the dataset size is not a problem. Is it possible to find more logs/details in PowerBI service to find out the root cause? 

Regards,

Ewelina

[v-eqin-msft]

Hi @ezarebska ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @ezarebska ,

You have touched the maximum refresh time of shared capacity. You could upgrade it to premium capacity.

Or use the following analysis tools to determine why a Power BI Report is slow:

1. Power BI Performance Analyzer
2. DAX Studio
3. VertiPaq Analyzer

You could refer to this blog for further help:

https://www.designmind.com/business-intelligence/power-bi-report-is-too-slow/

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[SMHolck]

Link goes to a 404?

[ibarrau]

Hi, when dealing with API it's not only about model size, it's also the speed of the API returning the values. Power Bi Desktop doesn't have a limit for refresh. The Service can't stay more than 120 minutes refreshing. You have two approaches.

1- Downsize data model, you can check this tips.

2- If the you have a small model and it stills take a lot to refresh, the problem might be the API. In that case you may want to build a structure before Power Bi. If you are taking a lot of history with the API start creating a storage with the past of the API and get request the minimum refresh options with it. Then you can read with PowerBI whatever storage you are using.

Hope this helps,