Publish/Transfer/Restore SSAS Model to Power BI

[vickyd]

Is there a way to transfer/import a SSAS Model into Power BI along with the data too?  

We currently have an On-Premise setup with SSAS and PBIRS and I've recently enabled PBI Premium per User and want to try things out there. 

I tried creating a backup .abf file in SSAS but when I try to use the restore option in Power BI Workspace connected via SSMS and click Browse, I get the error below. 

[v-stephen-msft]

Hi @vickyd ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[v-stephen-msft]

Hi @vickyd ,

These are blogs about restoring database, please kindly refer to:

https://www.mssqltips.com/sqlservertip/1906/how-to-restore-a-sql-server-analysis-services-database/

https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/backup-and-restore-of-ana...

Best Regards,

Stephen Tao

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

[GilbertQ]

Hi there

It is not possible to backup and restore an SSAS model to Power BI Premium.

You have to create the entire dataset and model in Power BI Desktop and upload the PBIX file to the Premium per User App Workspace.