Create & Connect to Azure Analysis Services Instance


Step 1 – Log into the Azure portal, then click on “Create a resource”

Step 2 – Create New – Analytics category, then click on “Analysis Services”

Step 3 – Create Analysis Services – beginning, blank form

Step 4 – Assign server Name, Resource Group, and Location

Step 5 – Pricing Tiers

Step 6a – Click “Select” Link to assign an Administrator

Step 6b – Click Select Link for Administrator – Administrator Chosen (only one choice was available in my tenant)

Step 7 – Storage Key Expiration Choices with “Never” selected, then click on “Create”

Step 8a – Deployment In Progress

Step 8b – Deployment Succeeded

Step 9 – Resource Home Page After Clicking – Go To Resource – Overview Page

Notice the URL / Server name

Step 10 – Firewall Disabled by Default, click to turn it on

Step 11a – Firewall Turned On

Step 11b – Add Permissive Firewall Rule – Then Click the “Save” button up top

Note: DO NOT use this type of firewall rule in production!

Step 12a – Models section, Manage page – no models by default, click on the “New model” button

Step 12b – New Model – Select “Sample Data” from the “Choose a data source” drop down list – Click Add (oops, not visible in the screenshot)

Step 12c – Model Created named “adventureworks” with a Compatibility of 1200

Step 13a – Connect to Azure Analysis Services in SSMS – Initiate Connection

Step 13b – Connect to Azure Analysis Services in SSMS – Notice the use of a URL specifying Protocol, Service, Location, Server Name, Authentication Type and and Username – Click Connect

Step 13c – Pick an Account – Subsequently Supply Password

Step 13d – View Azure Analysis Services Database in SSMS – All Nodes Expanded – Observe Available / Deployed Objects

Step 14 – Click on the Ellipsis of the Selected Model – Choices are “Open in Excel”, “Open in Power BI Desktop”, and “Open in Visual Studio”

Choose “Open in Power BI Desktop”

Step 15 – Observe the auto-generated .PBIX File – Download Produced, click on the Chevron and choose “Open”

Step 16 – Power BI Desktop – Model View – Notice No Data View in the Workspace pane and Live Connection: Connected

Step 17a – Connect From Power BI Desktop – Get Data – More

Step 17b – Connect From Power BI Desktop – Azure section – Azure Analysis Services Database then click on “Connect”

Step 17c – Connect From Power BI Desktop – Supply Server URL as seen above – Connect live chosen, click on “OK”

Both “Import” and “Connect live” are supported as documented here, although Import has limitations

Step 17d – Connect From Power BI Desktop – Pick Account

Step 17e – Connect From Power BI Desktop – Model View – No Data View – Live Connection as seen above

Step 18a – Connect From Power BI Desktop – Get Data -Supply Server And Database Names – this time, try “Import”

Step 18b – Connect From Power BI Desktop – Must Use Microsoft Account

Step 18c – Connect From Power BI Desktop – Navigator List Of Objects – All available objects selected – Resulting Memory Allocation / Tier Error

Step 19a – Scale section, Pricing Tier (Scale QPUs) page – Select B2 – B1 Didn’t Appear to Work at first, but actually did

Step 19b – Explore Pricing Tiers – Confirm Selection Alert, warning regarding current running command and queries, and tier switching restrictions

Step 19c – Explore Pricing Tiers – Scaling in Progress

Step 20a – Deployment Properties from Visual Studio

Documentation reference here

Step 20b – User Account Prompt – a database was created but was not populated with any objects