Forum Discussion

tljthree's avatar
tljthree
Icon for Advocate I rankAdvocate I
9 years ago

Import Analysis Services Tabular model into Power BI or Power Pivot

I have a need to take the Analysis Services Tabular model (Measure definitions, Calculated Column definitions, relationships between tables, etc) from SSAS Tabular and import into Power BI or Power ...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

tljthree

 

No, it's not possible. Ethier Power BI or Power Pivot is just a reporting and modeling tool, it's not a Analysis Services server which can host a Tabular database. They must "connect" to SSAS Tabular model to get data. 

 

Regards,

tljthree's avatar
tljthree
Icon for Advocate I rankAdvocate I
9 years ago

Simon,

 

Thank you for the answer, but I'm not sure it is accurate.

 

Yes, both Power BI and Power Pivot are reporting and modeling tools. But, both tools also run an instance of the SSAS engine underneath the covers.

 

I was *not* asking for the import so that I could have Power BI or Power Pivot to do the exact same job as SSAS Tabular.

 

Rather, I was asking, so that the model structure, including all of the measure formulas, could be shared with someone via a Power BI or Power Pivot model that was imported from SSAS Tabular.

 

There are valid use cases for this feature. 

  • vickyd's avatar
    vickyd
    Icon for Helper V rankHelper V
    8 years ago

    tljthree Did you manage to find a way to do this. I have a SSAS model that I'd like to convert to a Power BI Model just like you described and then continue development in Power BI. I'm basically struggling with development in Visual Studio using the latest SSDT (17.3) and SQl Server 2017 and planning to move to Power BI and then import it back as a SSAS Model using method decribed here.