Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Timeout 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)
Solved! Go to Solution.
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
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
30 | |
26 | |
23 | |
19 | |
15 |
User | Count |
---|---|
56 | |
37 | |
28 | |
24 | |
21 |