Refresh in PowerBI is triggering the same queries many times

[charanoffbit]

Hi All,

Refresh in PowerBI is triggering the same queries many times,

the query triggered is active and never finish

which consume resources (CPU-Memory-IO-etc)

slowing down the server and interrupting database schema changes (new MT, Indexes, etc)

Don’t trigger more than a query by report even though a refresh is executed.

Propose a query timeout at the db level for very long-running queries.

Just propose the timeout, DBA will implement it and affect only queries tunning on that DB/user.

[Anonymous]

Hi, @charanoffbit 

You can optimize your query design to ensure that your query is optimized to reduce the number of triggers. This can be achieved by using Query Folding to push the transformation back to the data source, reducing the burden on Power BI.

Or disable unnecessary loading, and if you have multiple referenced queries, consider disabling loading of intermediate queries that aren't directly used in reporting.

You can also use Table.Buffer, and in some cases, using Table.Buffer can prevent multiple requests to the same data source by caching the data in memory.

You can check the following link:

Why does my query run multiple times - Power Query | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[lbendlin · Accepted solution]

You're a little late to the party

https://blog.crossjoin.co.uk/2020/07/05/why-is-power-bi-running-my-sql-query-twice/