Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

I have had numerous email converstaions and an actual call last Friday abou this.

 

In my case we are using Big Query and apparently by design PBI will run a query twice once for metadat and then for the actual data.

 

However the problem comes when you use an ODBC driver to connect ( I am using Simba as advised by Google) this then multiples the running of a query up by anothe two times so in all at least 4 times the query will  run, inmy case it runs a query anything up to 6 times .

 

I ran a test and the query runs multiple times if you make amends in power query , just openeing the PBIX file. Just seting up the PBIX adding a conditional column in PQ aloing with a custom column closing reopening and refreshing in total a simple query ran 22 times in all...not good.

 

We have pushed back to t hem now to sort out, theu did suggest to use there Big Query API but the problem is it runs the whole tables in and even if you set up views in Big Query it brings them in stages so back to multiple queries.

 

Its back with them now :(

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous   do you have any updates on this?  We are running into a similar issue but ours is with an Azure Managed Instance.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    We are having the same problem. We run a complicated query with multiple joins. We're connecting to a Vertica DB running on AWS. We connect via ODBC. Running the query multiple times (concurrently!) means that the data base runs out of memory. It also costs us money unnecessarily.