Daily PowerBI refresh fails in most of the cases

[glg9]

I use daily data refreshes between Simplicate and PowerBI (OData).

The data in PowerBI service are stored in several datamarts in a PowerBI Premium workspace.

In the last few days the refreshes failed almost every time (90% of the cases) .

In the PowerBI log I can see a general error message:

Refresh start time,Refresh end time,Refresh Status,CPU Usage (milliseconds),Table start time,Table End Time,Dataflow table name,Partition name,Rows processed,Error
00:00:00,00:00:00,Not Found,Error: undefinedErrorMessage=The current operation was canceled because one or more operations failed…HttpStatusCode=0.

However, I tried to find the transaction in bridge online monitoring. (https://bridge-online.cloud/monitoring). Here I can find the transactions, and a more detailed error message:

“The data download was canceled after 4 seconds, such as by the user navigating away in the Power BI or Power Query user interface. (/*****.simplicate/odata4/Simplicate.CRM.OptionOrganizationCustomFields@spe).”

I have no idea what can be the problem. I do not navigate away, however, for refreshes it is allowed to close the browser, where you started. It can not be a problem. Somehow powerBi closes the connection?
Can someone help? how can I go deeper in analyzing the problem?

I did not find any solution in the community for my problem.

Thank you for all your support.

[forums]

It is recommended to try the download again.

A number of improvements have been made to avoid canceled downloads originating from PowerBI.com.

[glg9]

Thank you for the reply. I’ve learned, that using cache can solve the problem, because on the second trial the rows will come from the cache.

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.