Multiple duplicate queries while report refresh

[Anonymous]

Hi!
I've found that refreshing my ODBC source with pretty simple SQL-query generates multiple duplicate queries to my DB (up to 5 same queries for 1 refresh).

I tried [ConnectionTimeout = #duration(0,3,0,0), CommandTimeout = #duration(0,30,0,0)]) within Advanced Editor with no result.
It makes my DB suffer =(

How to prevent PBI from duplicating requests ?

[v-cherch-msft]

Hi @Anonymous

Do you use Referenced tables? It would affect the performance. Here is the post about improving Query Reference performance for large tables.

Regards,

Cherie

[Anonymous]

Hi!
Such query multiplication appears even with just 1 table in sources, no reference tables, no duplicate tables.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may refer to below post and try the workaround.

https://community.powerbi.com/t5/Integrations-with-Files-and/Stop-server-refresh-during-dashboard-preparation/m-p/572949

Regards,

Cherie

[Anonymous]

Thank you for link. Looks like what i need, but i have just 1 more question - will this settings affect Reports published on web?