Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
4 years ago
Solved

SSAS Cube, SSMS & Power Bi advice needed

Hi Community, I am not a warehouse expert but I am after some knowledge regarding Implementing SSAS Cube to our business. I currently work for a small organisation with 150-200 power bi end users an...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI cottrera,

    Did you mean the SSAS tabular cube? For that type of data source, we will use live mode to get data(the import will fix the file structure and data type) and some of the edit features have been disabled in this mode.
    You can take a look at the following link to know more about the difference between power bi connection modes:

    Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision! - RADACAD

    Regards,

    Xiaoxin Sheng

cottrera's avatar
cottrera
Post Prodigy
4 years ago

Hi Xiaoxin thank you for your resonse. Yes our data warehouse lead is trying to SSAS tabular cube. My argument is that I would prefere to do the modelling in power bi and add DAX functions there.  I didnt realise that transformation (power query ) was disabled on the live connection os SSAS. I can see a few business needs to use the live SSAS tabular cube. , such as K.P.Is. But the import connection to SSAS feels a better approach. However I will need to read the document on your link a few times to fully understand.

 

thank you

Richard😀