cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DLMDeveloper
Frequent Visitor

Migrating legacy Tabular model to Power BI datasets

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?

4 REPLIES 4
Mariusz
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,
Mariusz

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

Please feel free to connect with me.
LinkedIn

 

cjklim
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

Announcements
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