Can an Analysis Services ABF file be restored, or converted, to a PBIX?

Question

Is it possible to use Analysis Services to create an ABF backup file and then somehow restore it, or convert it, to a PBIX file? I know that an ABF file only contains data and metadata, but that is all we need. We don't need the visuals etc.

Answer 1

Please find in the following documentation the scripts and methods to restore abf's to datasets. It is a Premium (PPU, per capacity or embedded) option : https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-backup-restore-dataset

A new capability will be given by the product group to migrate your Analysis Services directly to Power BI through the portal : https://mybuild.microsoft.com/sessions/c5a57757-aee3-41f4-b03b-6fc94c56a4ed

You are able to restore to a dataset, but you won't be able to convert to pbix directly.

Script :

Place :

Output :