Deploying AdventureWorksDW to SQL Azure, Filling in Missing Indexes

By Julie Smith

 

I’ve been working with both Power BI and Azure SQL for the past nine months. One advantage to using Azure SQL Databases with Power BI is that there is no need for a gateway, personal or enterprise. The data refreshes every 15 minutes, period. You do not need to schedule a refresh or configure anything beyond the initial connection strings with server, database, user and password.

In planning for future SQL Saturday presentations in Chattanooga, Pensacola, and Atlanta I definitely wanted to show the happy green path that I feel is a viable pure cloud solution now for data warehousing. No problem, I’ll just use AdventureWorksDW, the warehouse sample database of our beloved Adventureworks bicycle shop, right?

Not so fast. There’s not a sample Data Warehouse for Azure SQL like there is for the transactional Adventure Works:

(Go here for full instructions on deploying AdventureWorksLT from the Azure portal.)

Not deterred, Continue reading Deploying AdventureWorksDW to SQL Azure, Filling in Missing Indexes