Migrating legacy Tabular model to Power BI datasets

[Anonymous]

Hi

We have many legacy Tabular models running in on-prem SSAS servers. We would like to migrate these to Power BI datasets. Is there a way to import the existing legacy model into Power BI or do we need to recreate it all manually?

[Mariusz]

Hi @Anonymous 

You can connect to you AS and select import model instead of connect live, later just publish to power bi service.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

We are trying to use the new read/write XMLA end points to deploy our existing SSAS models (directquery) to Power BI datasets.  However, they are using the legacy data source types pre 'Get Data', even after migrating to compatibility level 1500 the data sources are not upgraded and can't be deployed as Power BI datasets.  Any suggestions?    

[RakeshSinghr]

I havent tried this but you could 

1) build a sample dataset connecting to your legacy datsource within PBI desktop

2)publish to power bi service

3) use xmla read to import database back into visual studio

4) compare xmla with your upgraded project xmla n see if you can spot something obvious

[Anonymous]

Thanks @Mariusz . I have published my BI report and I can see the dataset it created. Will this dataset refresh from the SSAS Tabular model, or directly from  the data sources that the Tabular Model uses? I would need the second option so I can decommision the SSAS Tabular Server.