Power BI runs Query Multiple times

[Anonymous]

I'm developing a dashboard using Apache Hive as the backend storage (using an ODBC driver) and  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 > 15 minutes to complete. Having Power BI run the exact same query 3 times is causing issues.

[mahoneypat]

Please check out this post/video. 

https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/

Regards

Pat

[amitchandak]

@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/

[Anonymous]

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

[FreddySetiawan]

hi @Anonymous, did you managed to reduce the amount of query?

We are facing similar situation. Any workaround to avoid it?

[Anonymous]

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