Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
meyerovb
New Member

Auto refresh timeout

Some of the auto-refresh queries are freaking our redshift out.  It pops to 100% cpu and the query times out after 2 hours.  I want to set that timeout down to 10 minutes, for auto-refresh queries, or just all queries from app.powerbi.com through our on-premise gateway.  Where do I set this timeout property in powerbi?

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @meyerovb 

According to your description, you want to set the timeout property in power bi. I think there are two ways to achieve this:

First is to open the advanced options when connecting to the data source and enter the time out minutes, like this:

v-robertq-msft_0-1610436917612.png

 

Second is to open the advanced editor in Power query editor and change the M query to set the time out manually, like this:

v-robertq-msft_1-1610436917626.png

 

Here’s a solution that explains how to set a max run time / timeout for Power Query in detail, you can take a look and find if it’s useful:

https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-robertq-msft
Community Support
Community Support

Hi, @meyerovb 

According to your description, you want to set the timeout property in power bi. I think there are two ways to achieve this:

First is to open the advanced options when connecting to the data source and enter the time out minutes, like this:

v-robertq-msft_0-1610436917612.png

 

Second is to open the advanced editor in Power query editor and change the M query to set the time out manually, like this:

v-robertq-msft_1-1610436917626.png

 

Here’s a solution that explains how to set a max run time / timeout for Power Query in detail, you can take a look and find if it’s useful:

https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

GilbertQ
Super User
Super User

Hi there

 

You should be able to do this in the advanced editor in Power Query, and update the options for the timeout





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.