Forum Discussion

jmillar's avatar
jmillar
Icon for Helper I rankHelper I
7 years ago

Moving/migrating models between Power BI and SSAS

Hi all;   Our organization is currently looking at the best way to centralize data models -- SSAS or embedded in Power BI Desktop/Service.  One question that came up was whether it's possible to mo...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi jmillar

You could connect to SSAS Multidimensional models or Tabular data in Power BI Desktop,

if you need publish from Desktop to Service, then you need to manage a gateway and connect the datasources to the gateway.

Please read through these trials and have a try.

Connect to SSAS Multidimensional Models in Power BI Desktop

Using Analysis Services Tabular data in Power BI Desktop

manage data source-SSAS

Also please note the limitations

https://community.powerbi.com/t5/Desktop/Limitations-about-connecting-a-SSAS-multidimensional-model/td-p/450262

 

To import an existing Power BI dataset model into SSAS tabular, please follow below blogs:

IMPORT POWER BI DESKTOP MODEL TO SSAS TABULAR 2016

IMPORT POWER BI DESKTOP MODEL TO SSAS TABULAR 2017 USING AZURE ANALYSIS SERVICES

 

Best Regards

Maggie

 

  • jmillar's avatar
    jmillar
    Icon for Helper I rankHelper I
    7 years ago

    Thanks for the info -- there's no way to migrate existing SSAS tabular models easily to Power BI though?

     

    J

    • zoloturu's avatar
      zoloturu
      Icon for Memorable Member rankMemorable Member
      7 years ago

      jmillar,

       

      There is no direct way to do that for the current moment. It will be available somewhere in February-March 2019 once XMLA endpoints will be released. Details https://docs.microsoft.com/en-us/business-applications-release-notes/october18/intelligence-platform/planned-features.

       

      For now, you can copy and paste DAX and M (Power Query) code from SSAS to Power BI. It is also a fast option.

       

      Regards,
      Ruslan
      -------------------------------------------------------------------
      Did I answer your question? Mark my post as a solution!

      • dhooger's avatar
        dhooger
        Icon for Helper I rankHelper I
        7 years ago

        So is there a way to copy/migrate an SSAS Tabular cube to Power BI Desktop model.bim? I don't know what an XMLA endpoint is nor what to do with it. Thank you.