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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors