cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Power BI Service Refresh Issue - Azure SQL Server

Timeout setting on Power BI DesktopTimeout setting on Power BI Desktop

 

Hi Community,

 

I have a power BI report which is using 'import' mode on data from Azure SQL database.

I understand that there's a new feature released not too long ago, where user is able to set the 'command timeout (in minutes)' in Power BI Desktop.

 

As such, i have set my report to have timeoutof 240 minutes (4 hours) - ** Note: I have taken out the server and database names in this display**

 

However, when i deploy the report to the power BI service workspace, i get an error on refresh timeout

**Last refresh failed: Mon Jun 24 2019 07:40:54 GMT+0800
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
**

 

Question:

 

1) Does the command timeout setting in Power BI Desktop persist for the Power BI Service report? Or is the command timeout set in Power BI Desktop only applicable to data refresh in the desktop version, and is overwritten to default 120 minutes when published to Power BI Service? (Note that we are not on premium workspace)

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Power BI Service Refresh Issue - Azure SQL Server

Hi @Anonymous ,

Current power bi service has its timeout limitation on refresh/processing. Timeout parameter you setting in report side not able to increase the maximum on service side.

In addition, this refresh maximum timeout will be increased when you upgrade your license to premium.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Power BI Service Refresh Issue - Azure SQL Server

Hi @Anonymous ,

Current power bi service has its timeout limitation on refresh/processing. Timeout parameter you setting in report side not able to increase the maximum on service side.

In addition, this refresh maximum timeout will be increased when you upgrade your license to premium.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Power BI Service Refresh Issue - Azure SQL Server

Hi @v-shex-msft ,

 

Thanks for the confirmation. I have kind of guessed that the timeout parameter does not persist in the Power BI Service side, and the default 120 minutes timeout on Standard workspace could not be overwritten, unless the tenant moves to premium.

 

Cheers

Warren

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors