Microsoft Power BI Dashboards Step by Step, First Edition

11 Develop Power BI reports from Azure SQL

In this chapter:

• Overview of the Azure SQL portal

• Import data from an Azure SQL database into Power BI

• Create a Power BI report

• Set up a live data connection and data refresh functionality

In this chapter, you’ll learn how to develop a Power BI report that relies on data from an Azure SQL database as its source. You’ll also learn how to set up data refresh functionality for live data connectivity.

Practice files

As you work through this chapter, you’ll use one practice file, which you can access from the book’s companion website at https://aka.ms/PowerBIDash/downloads in the following folder: MSPBIDashboards\ch11. The file is as follows:

• SampleReportAzureSQL.pbix This file is a sample Power BI ...