Microsoft Power BI Dashboards Step by Step, First Edition

9 Develop Power BI reports from SQL

In this chapter:

• Import data from a SQL Server database into Power BI

• Create a Power BI report

• Set up a data gateway

• Configure Row-Level Security (RLS)

In this chapter, you’ll learn how to develop a Power BI report that relies on data from a SQL Server database as its source. You’ll also learn how to set up and configure a data gateway to enable Power BI users to access SQL Server database data through a live database connection and schedule refresh operations, as well as how to configure Row-Level Security (RLS) to restrict access to the report to authorized users only.

Practice files

As you work through this chapter, you’ll use two practice files, which you can access from the MSPBIDashboards\ch09 on ...