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:


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:


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:


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


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:



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



Now that was quick and easy wasn’t it.

8 Replies to “Getting your on premises SSAS Tabular model to Azure

    1. Similar to how it always has worked with SSAS, there is full scripting available to do test \ prod and change management.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.