Forum Discussion
import model to Analysis Services
Good day,
My question is related to this message of Microsoft Azure, where they say "There is currently no alternative for the Import from PBIX feature.".
If I need an aternative to import a model from Power BI to Azure Analysis Services, which could that be?
Hope you can help me! Thanks a lot in advanced.
The most flexible way is to use the PBI REST API to do this - https://docs.microsoft.com/en-us/rest/api/power-bi/
We have done something similar among other dataset manipulations. You can also use the TOM library to create dimensions, measures, relationships, etc. Here is the link for that. https://docs.microsoft.com/en-us/bi-reference/tom/introduction-to-the-tabular-object-model-tom-in-analysis-services-amo
The one below seems to do what you are looking for, but it's a manual process:
https://github.com/neaorin/ImportPowerBIToSSAS
Hope this helps.
Luis.
2 Replies
The most flexible way is to use the PBI REST API to do this - https://docs.microsoft.com/en-us/rest/api/power-bi/
We have done something similar among other dataset manipulations. You can also use the TOM library to create dimensions, measures, relationships, etc. Here is the link for that. https://docs.microsoft.com/en-us/bi-reference/tom/introduction-to-the-tabular-object-model-tom-in-analysis-services-amo
The one below seems to do what you are looking for, but it's a manual process:
https://github.com/neaorin/ImportPowerBIToSSAS
Hope this helps.
Luis.
Hi Anonymous ,
The suggestion of luisrh should be helpful. By my research, there is no better ways for us to achieve that.
May be you could import your data model to SSAS Tabular and then publish it to AS.
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
