Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI Dataset refresh timeout limit

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

3 Replies

  • Mohammad_Refaei's avatar
    Mohammad_Refaei
    Solution Specialist
    5 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

  • Kucrapok's avatar
    Kucrapok
    Helper I
    5 years ago

    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?