Convert PBIX file into Azure Analysis Services model


Using Azure Analysis Service, you can now convert a PBIX file into an Azure Analysis Services model.

PBIX file internally hosts an Analysis Service, which (model) can now be exported to Azure Analysis Services along with the underlying data set enabling the user to leverage all the cloud capabilities such as scale up/down.
This model can also be imported into Visual Studio where we can redesign the model, thus saving time from building the model from ground up.

 Steps:
  1. Go to Azure portal, Open the Azure Analysis Service Server
  2. Go to Overview blade -> Web Designer, click Open
  3. Click on add new model, choose import from Power BI desktop file.
  4. You now have successfully converted your PBIX into an Azure Analysis Services model
Limitations: PBIX files with direct query connection or live connection are not supported currently.

Note: If your file size is large and the request times out during the conversion, try adding default filters to you file. Once your model is ready, open SSMS and process your model by connecting to the underlying database.




No comments:

Powered by Blogger.