cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Scheduled Refresh Timeout Error but Works on PBI Desktop

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:

Timeout.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

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.

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

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. 

Highlighted
Helper III
Helper III

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

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?

Highlighted
Super User III
Super User III

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

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.

Highlighted
Helper III
Helper III

Re: Scheduled Refresh Timeout Error but Works on PBI Desktop

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.

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.