topic Re: Scheduled Refresh Timeout Error but Works on PBI Desktop in Report Server

Scheduled Refresh Timeout Error but Works on PBI Desktop

tmendoza — Wed, 07 Aug 2019 20:18:45 GMT

Hello all,

I've got a dashboard that has a scheduled refresh for everymorning at 6am.

Unfortunately it does not work. Every time the dashboard is refreshed, it's timeout expires (60 minutes) and it stops the other queries from refreshing as well. So I can't automatically update my data.

I have to pull the report into PBI desktop, refresh and then save it back to the server in order to refresh the data.

So, works on desktop, but not the server.

Does anyone know why this could be?

Please refer to the photo below:

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

d_gosbell — Wed, 07 Aug 2019 21:12:45 GMT

Check out this thread https://community.powerbi.com/t5/Report-Server/Timeout-at-Microsoft-AnalysisServices-Tabular-Model-SaveChanges/td-p/759085

The user was having a similar timeout error at 60 minutes and I believe we found a way to increase this setting on the server.

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

tmendoza — Wed, 07 Aug 2019 21:30:05 GMT

Not really following your solutiond_gosbell ,

You're suggesting that I add and external command timeout to the "outer" msmdsrv.ini. I don't even know what that is.

Is this something I navigate to using the file explorer?

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

d_gosbell — Wed, 07 Aug 2019 22:50:46 GMT

Sorry, that "outer" term was something the guy came up with in the other thread and I was just matching his terminology.

But the article he references https://docs.microsoft.com/de-de/power-bi/report-server/scheduled-refresh-troubleshoot#analysis-services%C2%A0 tells you about the msmdsrv.ini file which is stored at <install directory>\PBIRS\ASEngine in my install (May 2019) this already has an External Timeout setting property predefined with the follow setting defined under the <ConfigurationSettings> element

<ExternalCommandTimeout>86400</ExternalCommandTimeout>

This setting is in seconds so this is effectively a 24 hr timeout. If this setting is not present in msmdsrv.ini the server will default to using a value of 3600 seconds ( 60 minutes)

After changing this setting you would need to stop and start your PBIRS instance using the configuration tool.

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

tmendoza — Wed, 07 Aug 2019 23:16:33 GMT

Got the darn thing to work.

I did a restart on the SSRS service that my queries were pulling from and my refreshes are completing successfuly again!!!

The memory usage was pretty high, so this must have been bottlenecking things.