Forum Discussion
Power BI runs query multiple times on backend?
I'm developing a dashboard using Apache Hive as the backend storage (using an ODBC driver) and I've noticed something strange. When I add a datasource, Power BI runs the query 3 times for each ref...
This is simply unacceptable. This is the definition of death by a thousand cuts. We have over 60 dashboards spread across 3 servers and that's still not enough to off load the issue this is creating. If a dashboard is pulling in 5 tables thats 10 connections and executions to pull one dashboard.
In the examply below I ran a trace on the dashboard refresh and you can clearly see the query running twice with a connection reset inbetween. It's impossible to negate the negative effect of this many connections even to multiple servers.
The Problem occurs when Power BI issues a Hive Query something like 'SELECT * FROM DATE' but if imported as the table it uses only one connection. Hope this helps
Thanks
