Does connecting to SSAS cubes by live connection improve data loading time?

[vickyArce]

Does connecting to SSAS cubes by live connection improve data loading time?

I have large sets of data, and the query in SQL does take longer time because of the nested loops. If I creat a cube in SSAS, then live connect to this cube in power BI, will the loading time be shorter?

Any other suggestion will be welcome. Thanks.

[v-yuta-msft · Accepted solution]

@vickyArce ,

Yes, when you use live connection mode, there's no data imported to power bi so it's faster. Please refer to this similar case:

https://community.powerbi.com/t5/Desktop/Analysis-Services-Connect-live-vs-import-help/td-p/207437

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vickyArce]

Thank you for your replay.