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 Smile Let’s go.

First I create a new AS Azure instance:

image

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:

image

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:

image

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

image

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 Smile) it is restored:

image

 

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

image

 

Now that was quick and easy wasn’t it.