Power BI Dataset refresh timeout limit

[Anonymous]

Hi Team, 

My published report dataset is having 4gb and configured the schedule refresh and its getting failed due to timeout limit more than 12minutes. Im using premium capacity workspace.

The refresh operation failed because it took more than 120 minutes to complete. consider reducing the size of your dataset or breaking it up into smaller datasets in power bi service

Could you please help on this issue

[Kucrapok]

Hello,

Can you give us an idea of the model?

How many tables do you have? In your Fact table, how many rows and columns do you have?

[Mohammad_Refaei]

You can adjust the timeout period for this connection in PBI Desktop.

You might also consider applying incremental refresh if you are not using it yet... this should significantly speed up the refresh process

[DaxPadawan]

HI @Mohammad_Refaei does this setting carry over when we publish to Service? We're connecting to an on-prem SQL Server using a Gateway.