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
ugurdemir's avatar
ugurdemir
Icon for Helper II rankHelper II
2 years ago

It's 2024 and problem still exists in SQL Server connection.
I think Microsoft team has lost on the way of solving this problem. Otherwise they would give a written answer

 

here is my test script,

let  
  Source = Sql.Database(".", "TEST", [Query="select * from [dbo].[ProductSold]"]),  
  selectARow = Table.SelectRows(Source, each [ProductID] = 3 ),  
  selectAColumn = Table.SelectColumns(selectARow,{"ProductID"})[ProductID]{0},  
  testProc = Sql.Database(".", "TEST", [Query="exec test2 " & Text.From(selectAColumn)])
in  
  testProc

 

In this situation "select * from [dbo].[ProductSold]" query runs only once but the "exec test2 " query runs twice.