I create a query in Power BI Desktop against a data source. Power BI Desktop insists on executing it multiple (usually three) times. This makes Desktop slow and for back-end data sources exerts add...
It's now 2024 September and problem still exists. (in my opinion this is not an idea, it must be descripted as an issue)
I'm in PBI desktop and have a simple code to test the issue
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.
