Getting your on premises SSAS Tabular model to Azure

Ok today a short one to show how easy it is to take your on premise SSAS cube over to Azure. You often see data migration tools and such for SQL and other platforms but for SSAS it is SUPER easy  Getting your on premises SSAS Tabular model to Azure Let’s go.

First I create a new AS Azure instance:

 Getting your on premises SSAS Tabular model to Azure

The important thing is to make sure you select a storage location.

Now while that is creating I go to my on premises model using SSMS and create a backup:

 Getting your on premises SSAS Tabular model to Azure

Then in the mean time my Azure AS database is created. I upload the ABF file to the Azure blob that I selected or configured during my Azure AS setup.  I use Azure Storage Explorer for this:

 Getting your on premises SSAS Tabular model to Azure

Now after the ABF is available on Azure you can start the restoration, I just connect to Azure AS with SSMS:

 Getting your on premises SSAS Tabular model to Azure

As you can see I can now pick the ABF from the blob store directly in SSMS. Select the database you want and press OK.

A few seconds later (based on the size ofcourse  Getting your on premises SSAS Tabular model to Azure) it is restored:

 Getting your on premises SSAS Tabular model to Azure

And done! Now I can connect to it using Power BI:

 Getting your on premises SSAS Tabular model to Azure

Now that was quick and easy wasn’t it.

Let’s block ads! (Why?)

Kasper On BI