Forum Discussion
Slow performance with PowerBI Service and Desktop even though underlying query executes quickly
Super UserHey Anonymous
personally I do not consider a query quick that takes 7sec to provide a result, except a huge amount of rows is returned.
Of course, you have to add additional time to transfer data from the data source (I'm surprised that Power BI Service is faster than Desktop) and also to render the data.
You can use the Performance Analyzer to trace what's going on:
And finally, if you are using transformations inside Power Query that do not fold or using DAX to create measures on top of a direct query, this can also slow down the final "presentation".
Anonymous wrote:
...It looks like a similar performance issues have been seen when using other query engines, but no real solution has been provided. Has any encountered similar issues?
I'm interested in the above statement, as I'm working with a large Power BI environment, with many direct query datasets (some respond blazing fast, some don't, but none is slow), I want to avoid the bad experiences you have made. Maybe you can be so kind and provide more details.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom