How to migrate AAS/SSAS cube to Power BI premium?

Question

We have few cubes located in on-prem SSAS and on AAS (Azure analysis services). The report connect to the cube via live connection.

We are planning to migrate the cubes into the Power BI Premium workspace.

I want to ask - how do I migrate the cube from analysis services to Power BI Premium? Do I publish the model from visual studio analysis services project into Power BI premium workspace? Or do I convert the visual studio analysis services project into .pbix based data model?

Answer 1

Hi Easiest way is to migrate using Tabular Editor

First in power bi make sure you have enabled XMLA endpoint read write enabled in the tenant. Refer below SS

Get the analysis services url and click on From DB and paste the AAS url

Be mindful of the compatibility level Recommending to put it into 1565 range

After this deploy into the premium workspace.

Get the wokrspace connection string from below mentioned place.

Paste it in below.

Deploy by picking following settings.

And Deploy.

UPDATE

Now AAS model migration is available natively in powerbi refer below link for more information,

https://learn.microsoft.com/en-us/power-bi/enterprise/aas-pbi-migration-overview

Answer 2

Deploying the code like @amelia suggested is a great way to migrate and the answer was extremely well written. For AAS there is a new built-in migration process which backs up and restores the AAS model to Power BI. Then it enables redirection so that existing Excel reports (or other client tools) automatically are redirected to Power BI.