Move your pbix datamodel to Azure Analysis services – #powerbi
After the Azure Analysis Services web designer was discontinued per march 1 2019 – link – there is no official tool to do a move of a PBIX datamodel to Azure Analysis Service. But by using a few different tools we do have ways of doing it anyway.
Step 1 – DAX Studio
Open your PBIX file in the Power BI Desktop and then open the DAX Studio (link to download) and connect DAX studio to the PBI model
In the status bar you will see the local port of the Analysis model running on your machine
Step 2 SQL Management Studio
Connect to Analysis Services using the server address from Step 1
This will give you a connection to the model
Now right click the Database and choose to script the Database to a new Query Editor window (or the clipboard)
Step 3 Connect to Azure Analysis Services
Use the SQL Server Management Studio to connect to Azure Analysis Services
Select to run a New XMLA Query on the server
And paste the query created in Step 2 in the new Query window – You can specify a model name in the highlighted area
Run the Query – and after a few seconds you should get this result – that the query has completed successfully.
And after a refresh of the server object you should see the newly scripted data model
Step 4 Finish the move
Now depending on the data sources in your model you need to setup the necessary connections and gateway.
And use your favourite Analysis Services tool to modify model – for instance the Tabular editor ( link )
You will have to go through all your data sources and Tables to make sure the connections and M-Scripts are functioning.
Tip
Before you script your PBIX data model – turn off the Time intelligence in your current file – otherwise you could get a lot of extra date/time tables in your model
