Forum Discussion
Multiple duplicate queries while report refresh
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 ?
Hi Anonymous
You may refer to below post and try the workaround.
Regards,
Cherie
4 Replies
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
Hi Anonymous
You may refer to below post and try the workaround.
Regards,
Cherie