Storage mode to use for this scenario

[YoungLearning]

Shouldn't it be LiveConnect, hence the report can refresh the visual using the existing data, and import mode for Dataset file since it there's no real time requirements specified?

[SaiTejaTalasila · Accepted solution]

Hi @YoungLearning ,

As per my knowledge this is my view 

They mentioned combine two tables it's only possible with import mode(transformations &helper queries are required).Live connection is a way of connecting a Power BI report to a Power BI semantic model.

Thanks,

Sai Teja 

[v-xuxinyi-msft · Accepted solution]

Hi @YoungLearning 

Thanks for the reply from @SaiTejaTalasila and @foodd .

The question mentioned the need to merge two tables, and liveConnect mode cannot coexist with other modes. If the two connection modes are mixed together, it will become a composite mode. Composite mode can only mix Import and DirectQuery, or integrate multiple DirectQuery data sources.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand#composite-m... 

Best Regards,
Yulia Xu

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

[SaiTejaTalasila]

Hi @YoungLearning ,

As per my understanding it will be 

Report file -live connect 

Dataset file -import

Thanks,

Sai Teja 

[YoungLearning]

Could you please perhaps elaborate further or cite the sources to your answer?

[SaiTejaTalasila · Accepted solution]

Hi @YoungLearning ,

As per my knowledge this is my view 

They mentioned combine two tables it's only possible with import mode(transformations &helper queries are required).Live connection is a way of connecting a Power BI report to a Power BI semantic model.

Thanks,

Sai Teja 

[foodd]

Usually, you should use the discussion forum that is shown in the screenshots of your current and previous posts. If that's not enough, you can contact the support channels related to the product you're studying. The training or test vendor is always the best source for the kind of answers you're looking for.