Frecuent Scheduled Refresh Failures

[tteguayco]

Hi everyone,

During the last couple of weeks, some of my reports have been failing while executing their scheduled refreshes, receiving the following email notification:

Although it says "this is usually a transient issue", it keeps failing very frequently.

As far as I know, the Microsoft SQL Server it uses as a data source does not have a very good performance. Could the performance of this server be involved in the problem or there may be other related issues?

Some other relevant details to take into account are:

- There are some other reports using the same data source that also fail.

- A Power BI gateway is used to schedule the refreshes.

- Neither of the datasets for these reports return too much data (about 15K rows for the biggest one).

- Data Import is used, instead of DirectQuery.

I have already contacted the support as well, but after the Gateway upgrade they told me to do, the issue is still happening.

Thanks in advance!

Kind regards,

Teguayco

[venal]

@tteguayco 

If possible, can you please try to upload the gateway logs to investigate.

If you have any concerns, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[tteguayco]

Hi @venal,

I didn't know gateways generate log files. I have obtained two of these following the instructions in this documentation, but have not seen any errors: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot#collect-logs-from-t...

One thing I realized: I have two different copies of one of the report that is frequently failing, with the same scheduled refresh. I have already modified one of these refreshes to prevent them from being overlapped. I will see if they fail less after this change.

Another interesting question would be if there is any way of getting the list of Power BI reports whose scheduled refreshes are executed using which gateway. This would help a lot to have a higher control on which report is using which gateway.

Kind regards,

Teguayco

[v-xicai]

Hi @tteguayco ,

There are several points you may considerate:

1.Ensure that you've added one or more data sources of your dataset to the gateway, as described in Add a data source.

2.Verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.

3.Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

4.If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .

Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

5.Please make sure the gateway is online, and try to upgrade the gateway to latest version.

6.Please set schedule refresh for different datasets at different times, make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities. Also we suggest that you first disable all refreshes on all capacities. Then slowly enable the refreshes one by one. Make sure refreshes are staggered apart (e.g. 1 hour apart), and that no more than max concurrent refreshes happen at overlapping time periods.

7.Power BI Pro or Power BI Free supports uploading Power BI Desktop (.PBIX) files that are up to 1 GB in size. Power BI Premium supports uploading Power BI Desktop (.PBIX) files that are up to 10 GB in size. If you need to upload PBIX file that is larger than 10 GB, consider to move data from your source to SQL Server, Oracle or SSAS, then use DirectQuery/Live connection.

You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .

Best Regards,

Amy

Community Support Team _ Amy

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

[tteguayco]

Hi @v-xicai,

Thanks for your response.

All the points that you say have been tested/revised but #6. How can I know which is the "max parallel refreshes" that I am able to configure?

And what do you mean by "capacity" when you say "also we suggest that you first disable all refreshes on all capacities". Do you mean the data source (SQL Server) or the Power BI Gateway being used?

Kind regards,

Teguayco