Incremental refresh report first refresh

[Anonymous]

Hi

So I\ve read that when you upload a report that has incremental refresh the first scheduled refresh may take more time to refresh and the ones after the first refresh will be quick.

I have incremental refreshing set up correctly, no errors shown and all seems to be good but in service the first refresh takes so long, first I had manually added timeout to the source for 120 minutes but the refresh took more than that and emailed me that it failed due to timeout, then I increased the timeout to 240 minutes and still got error:

Hide	Scheduled	18/03/2021, 07:02:24	18/03/2021, 09:15:28	Failed	There was an error when processing the data in the dataset.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net Activity ID: 7726ffb7-40f1-4b2f-ba2a-2f04ffe21228 Request ID: cc6746f6-8190-4250-bdc3-9355f498fae0 Time: 2021-03-18 07:15:28Z

How am I supposed to get this to work if this timeout error comes everytime?

Report is obviously in import mode and data comes from SQL server.

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you increase the CommandTimeout and the ConnectionTimeout parameters to two hours to see if it works. The default value for ComandTimeout is ten minutes and the default value for ConnectionTimeout is driver-dependent. You may go to Power Query to modify them.

In addition, do you use Premium workspace? Here’s the refresh time limitation for a scheduled refresh in Power BI service:
Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.
Therefore, I suggest you to upgrade your workspace to Premium workspace if you have started the PPU trail, like this:

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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