Forum Discussion

kishoresakamuri's avatar
kishoresakamuri
Advocate II
9 years ago

Cube connection

HI   I am using the datasource as analysis services i am getting to two options 1.live connection 2.import data when i connect to live we are not able to create custom columns and the measures ....
Custom Visuals
Dashboards
Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool,

 

1. Live Connection.

    We can't do anything using DAX here. All the stuff u have to in SSAS cube itself.

     In live connection there is no data import on your Local so it should be fast.

 

2. Import mode.

     We can do all the DAX stuff here.

     All the datas are loaded in local so it might slow peformance.

 

My Suggestion:

 

Go with Live Connection, Without live connection y u went to cube ?

if u want to create new column or measure we can do in SSAS Cube itself. it was increase your performance dude.

 

SSAS - Power BI id best combination , when u go with Live connection 

MikeB's avatar
MikeB
Regular Visitor
9 years ago

Hi Baskar,

 

Thanks for your reply. What about when you need to connect two data sources and would like to build calculations off of them? i.e. I would like to leverage a sales report and a forecast report that are from different sources. If I use a live connection I can no longer use the "Get Data" function?

 

In this case, is building a DAX import my only option?

 

Thanks!

Michael