Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Incremental refresh report first refresh

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
Scheduled18/03/2021, 07:02:2418/03/2021, 09:15:28FailedThere 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.

1 ACCEPTED SOLUTION
v-kkf-msft
Community Support
Community Support

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.

v-kkf-msft_0-1616400975276.png

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:

v-kkf-msft_1-1616401013279.png

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.

View solution in original post

1 REPLY 1
v-kkf-msft
Community Support
Community Support

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.

v-kkf-msft_0-1616400975276.png

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:

v-kkf-msft_1-1616401013279.png

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.