Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Migrating legacy Tabular model to Power BI datasets



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?

Super User II
Super User II

Hi @DLMDeveloper 


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


Best Regards,

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

Please feel free to connect with me.


Frequent Visitor

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?    

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

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.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors