Scheduled Refresh Timeout Error but Works on PBI Desktop

[tmendoza]

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:

[tmendoza · Accepted solution]

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.

[d_gosbell]

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

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. 

[tmendoza]

Not really following your solution@d_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?

[d_gosbell]

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-serv... 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.