live connection vs import data on ssas

[MP_123]

hi all,

can someone please help me considering whther to connect live or import my cube to pbi desktop?

i know in import there is a memory issue, is on live to?

i know also about the editing issue on live connection.

performance? is there a different?

is there another part i should think about?

thanks a lot!!

[Greg_Deckler · Accepted solution]

A lot of this comes down to how much data you are talking about. Even Power BI Pro is limited to 10GB so if your data exceeds that, then you probably need to look at a live connection because the alternative is that you import all your data into the model. Generally, performance is going to be better with a non-live connection because all of the data exists in the model and you do not have to essentially make a query call to go get the data "live".

[dramus · Accepted solution]

I can't answer to SSAS, but I have been working with Oracle using a live connection (Direct Query).

Here's a list of things I could not do inside Power Bi Desktop off the top of my head:

• Add columns or measures.
• Any data transformation.
• Bi-Directional relationships.
• Create data tables directly inside PBID.
• Use more than one data source (You can use it more than once, but you can't use two different ones).

I suspect that most if not all of these restrictions will go away over time, but for right now it is something to consider.

You can start down the Direct Query path and if you find that you need to change it later to gain some needed PBID functionality you can. But there is no going the other direction once you disable the direct query.

Hope this helps.

[MP_123]

thank you both, really helped. @dramus@Greg_Deckler

[MP_123]

@dramus@Greg_Deckler

a little question -

what about the publish to web option?

i know that there is an issue with it when connectiong "directQuery"

thanks!

[dramus]

I have not noticed any issues on the Oracle Direct Query. What issue are you refering to?

[Greg_Deckler · Accepted solution]

A lot of this comes down to how much data you are talking about. Even Power BI Pro is limited to 10GB so if your data exceeds that, then you probably need to look at a live connection because the alternative is that you import all your data into the model. Generally, performance is going to be better with a non-live connection because all of the data exists in the model and you do not have to essentially make a query call to go get the data "live".