Solved: Multiple duplicate queries while report refresh

Anonymous · ‎12-24-2018

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 · ‎12-26-2018

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

Community Support Team _ Cherie Chen
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

v-cherch-msft · ‎12-24-2018

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎12-24-2018

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

v-cherch-msft · ‎12-26-2018

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.