Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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?

Need Help

4 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        RakeshSinghr
        Icon for Resolver I rankResolver I
        6 years ago

        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