Live connection vs Direct query performance

Hi Anonymous and Jayee ,

Thanks for your replies ! 

I'll try to give a more accurate description. First, I'm talking about report usage performance.

Initially, I have a report connected to a SSAS cube (A). It takes approximately 15 seconds to load the report page.

Then I migrated the cube to a dataset in Power BI Premium (B) and connected my report to this dataset in Live Connect. Again, it takes approximately 15 seconds to load the report page.

Finally, I tried to connect my report in Direct Query to the dataset B. So I have my report connected to a dataset C that is connected in Direct Query to the dataset B. Now my report page loads in 5 seconds.

Summary:

A) report connected in live connection to on prem SSAS cube loads in 15 seconds

B) report connected in live connection to Power BI Premium dataset loads in 15 seconds

C) report connected in Direct Query to Power BI Premium dataset (B) loads in 5 seconds

I refreshed my browser cache every time. 

Hope it is more clear. Let me know if you have any idea,

Thanks!