Import just the data model from SSAS to pbix file

[Anonymous]

Hi All,

We have SSAS tabular cubes and are trying to get rid of them and manage the model in PowerBi.

However the model in SSAS has lot of measures and calculated columns which will take time to redo.

So is there a way to just import the model from SSAS tabular to power BI and make it use SQL server as source

Thanks

[jdbuchanan71 · Accepted solution]

@Anonymous 

I don't think there is a way to directly import the model like open model.bim using PowerBI desktop although that would be great if we could.

You can use the Vertipaq Analyser to extract the measures and claculated columns from the model which may help some.

https://www.sqlbi.com/tools/vertipaq-analyzer/

[Anonymous]

sad to hear that...

I will explore the vertipaq.. thank you very much