topic Re: Power BI Dataset refresh timeout limit in DAX Commands and Tips

Power BI Dataset refresh timeout limit

Anonymous — Fri, 13 Aug 2021 08:10:17 GMT

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

Re: Power BI Dataset refresh timeout limit

Mohammad_Refaei — Fri, 13 Aug 2021 13:43:43 GMT

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

Re: Power BI Dataset refresh timeout limit

Kucrapok — Sat, 14 Aug 2021 01:21:44 GMT

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?

Re: Power BI Dataset refresh timeout limit

Anonymous — Mon, 04 Dec 2023 07:31:00 GMT

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.