on 01 Feb 2019 23:43:45
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 additional load that can also incur additional costs.
Note: I am not talking about the scenario where a query is referred to multiple times in M, rather just a simple query loaded into one table in the data model. I assume the engine is checking data types, etc - but the current approach is very slow/painful. Optimisation is needed!
- Comments (15)
RE: Stop Executing Queries Multiple Times
Hi Microsoft team !
What about this really important issue ?
It is not acceptable from customers not to have any answer or solution for this old issue, which is really problematic for us as several users run queries from PowerBi Desktop to our datasources (like Hive) and this become now a real performance issue for our platform.
We really need a solution from your team. Quickly.
RE: Stop Executing Queries Multiple Times
How do you monitor this type of activity? With the Prem-logs? We are struggling with refresh performance, timeouts and failure and I would like to see if this is part of our issue. This seems like a good way to make Microsoft customers pay for more capacity.
RE: Stop Executing Queries Multiple Times
If it does not get fixed, it may be the death of the product here. I will need to use something else.
RE: Stop Executing Queries Multiple Times
We have been fighting the same issue & agree it's a bigger problem with large datasets. We commonly see duplicate requests issued to the source (via on prem gateway) by an otherwise simple Power BI Online refresh.
RE: Stop Executing Queries Multiple Times
Very much needed for big data. Having a query that hits billions of records run multiple times can add hours in processing time. We currently have to write the data to a temp table so we can bring it into Power BI, but only one dashboard is using that particular dataset, so...