Timeout value in powerbi service

[amokrane]

Hello,

I have a dataset for 3 days I can not update it on Power BI service, knowing that on DESKTOP it is normally updated in 30 minutes. the dataset is powered from a SQL server database, via a data gateway. the data gateway is well updated. the incremental update is activated and the dataset retrieves only the data of the last 3 days to each update.

Here is the generated error message :

Data source error: The XML for Analysis request timed out before it was completed. Timeout value: 17998 sec.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 680ec1d7-edea-4d7c-b87e-859ad2dee192
Application ID: fcde3b0f-874b-9321-6ee4-e506b0782dac
Time: 2020-12-24 19:03:30Z

What is the solution to this problem please.

Thank you

[v-yuaj-msft · Accepted solution]

Hi @amokrane ,

How long is it running before timing out?

One thing you could try is setting the Time out parameter on the connection. Try setting this to something larger than 3600, like 7200 for 2 hours or even 36000 for 10 hours.

Default number if you put nothing = 10min

Based on your description, I think the above error could be caused by that the data model size in your PBIX file is too large. As stated in this blog, refreshing the dataset will give an error message indicating you that your dataset is too large when data model size grows beyond 1 GB.
If the data model size is too large, please break up your dataset into smaller datasets and refresh them in Power BI Service.

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

That doesn't look like a SQL server data source, it looks more like a SSAS cube. Please confirm.

with SQL server connections you can set two different timeouts, the ConnectionTimeout and the CommandTimeout.  you want to specify the latter.

Any chance you can make your SQL server perform better? 30 minutes is a long time in any case.

[amokrane]

No it's not a SSAS cube but a SQL SERVER database.