Power BI runs Query Multiple times

Question

I'm developing a dashboard using Apache Hive as the backend storage (using an ODBC driver) and&nbsp; When I add a datasource, Power BI runs the query 3 times for each refresh. Some of these queries are quite complex on huge datasets, that can take &gt; 15 minutes to complete. Having Power BI run the exact same query 3 times is causing issues.

anonymous · Answer

actually it runs query 1 for evaluating, query 2 for waiting for dns and query 3 for loading data.&nbsp;

freddysetiawan · Answer

hi&nbsp;Anonymous,&nbsp;did you managed to reduce the amount of query?We are facing similar situation. Any workaround to avoid it?

amitchandak · Answer

Anonymous , Are you using bi-directional relationships? these will cause more queries
Also refer:
https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer
https://www.red-gate.com/simple-talk/sql/bi/direct-query-power-bi/
&nbsp;
&nbsp;

mahoneypat · Answer

Please check out this post/video.&nbsp;https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/RegardsPat&nbsp;

anonymous · Answer

no sir, it is simple one to one queries. means every visual has only one table at backend. no relationships.&nbsp;

Forum Discussion

Power BI runs Query Multiple times

5 Replies

Related content

Power Query Combine Multiple Files From Folder

Power Query dates

Data transform using power query

Power Query - Aggregate multiple columns within group by

ayuda en power query