Forum Discussion
Anonymous
7 years agoNot applicable
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...
- 7 years ago
Hi Anonymous
You may refer to below post and try the workaround.
Regards,
Cherie
v-cherch-msft
7 years agoMicrosoft Employee
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
- Anonymous7 years agoNot applicable
Hi!
Such query multiplication appears even with just 1 table in sources, no reference tables, no duplicate tables.- v-cherch-msft7 years agoMicrosoft Employee
Hi Anonymous
You may refer to below post and try the workaround.
Regards,
Cherie
- Anonymous7 years agoNot applicable
Thank you for link. Looks like what i need, but i have just 1 more question - will this settings affect Reports published on web?