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 |