Chapter 3 Power BI on Microsoft Stack
As discussed in the previous chapter, Power BI can be integrated with hundreds of data sources. One of the most prominent data sources is SQL Server, which is a relational database management system introduced by Microsoft. It is primarily used in business applications.
This chapter provides an in-depth description of integrating Power BI with SQL Server to create interactive reports.
Getting Data into Power BI from SQL Server
There are two options to bring SQL Server data into Power BI Desktop, as follows:
–Import
–DirectQuery
Using the Import Option
In Power BI Desktop, the Import option imports the selected tables and columns. The imported data can be used to create visuals.
The Import option contains ...
Get Power BI Data Analysis and Visualization now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
