Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
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:
Second is to open the advanced editor in Power query editor and change the M query to set the time out manually, like this:
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.
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:
Second is to open the advanced editor in Power query editor and change the M query to set the time out manually, like this:
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.
Hi there
You should be able to do this in the advanced editor in Power Query, and update the options for the timeout
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
19 | |
17 | |
16 | |
14 | |
11 |
User | Count |
---|---|
41 | |
24 | |
22 | |
18 | |
11 |