Forum Discussion
Live connection vs Direct query performance
Hi, I have a SSAS cube that is slow. We need to optimize it but it requires a big effort. We migrated it to Power BI Premium but the performance was the same. Then I tried to connect to the datase...
Hi Fcaill
You need to more clear while creating a post and description is vauge.
Not sure performance means you are taking about refresh performance or report usage performance....
Any way please got throught the below website from guy in cube they are explained clearly difference between import vs direct query vs live connection
https://guyinacube.com/2021/01/28/power-bi-get-data-import-vs-directquery-vs-live-2021/
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!