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
MikeB's avatar
MikeB
Regular Visitor
9 years ago

Hi Baskar,

 

What would you recommend for scenarios where you want to leverage two data sources, one cube and one excel table? When you use the cube as a live connection, the Get Data function is no longer available, so you cannot build calculations, connect other data etc. In this case is using the import model and DAX your only option?

 

Please let me know.

Thanks,

Michael

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Dear Friend,

 

Sorry for my previous one. 
Import is always faster then live connection. It is based on the data size.

let come to here.

 

1. If u connect one source as live connection we can't use another connection as import.

 

solution for this scenario.

1. Try to import that excel file into cube and do the all modelling and calculation in cube itself. 

or 

2. Change the live connection to import then do the calculation here.

 

Note :

Few updates back Power BI introduce one new feature. that we can do the DAX calculation in power bi desktop if even connected with Live source too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Baskar ,

    Hope you or some one of Contributors team see this post and reply. Can elaborat on how to import an offline file(i.e. Excel, Json, sql, etc.) I can push to cube abd use DAX or any potent manipulator?

    Please answer...

    Thanks