Move/Transfer/Migrate Power BI file to Analysis Services

[Anonymous]

Good day

I am trying to Move/Transfer/Migrate my development done in Power BI Desktop from the Power BI file into Analysis Services (not Azure).

I have seen some posts on the topic but it did not help for various reasons eg could not script the database, Azure Designer was discontinued etc.

Can somebody perhaps engage with me to check how this can be achieved? There is weeks of development of relationships and measures which I would like to not manually replicate in Analysis Services.

Thank you kindly

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may refer to the article Migrate a Power Query or Power BI file to a local SSAS instance, see the steps as it described:

1. Import the Excel file in Power BI Desktop, save and close the pbix-file
2. Open Azure Analysis service, open the Web Designer and create a new model where you import the pbix
3. Open that model with Visual Studio (this will actually create a download that holds the VS-file)
4. Open that file in Visual Studio, load the data, build and change the deployment target from Azure to you local SSAS-database before deploying.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , check if these can help. If not checked already

https://azure.microsoft.com/en-in/blog/import-power-bi-desktop-files-into-azure-analysis-services/

https://eriksvensen.wordpress.com/2019/04/19/move-your-pbix-datamodel-to-azure-analysis-services-powerbi/

[Anonymous]

Hi Amit

Thank you for the prompt response. I have seen these two, but they are both for AZURE Analysis Services opposed to just Analysis Services.