Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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/
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |