Welcome to Excel Jet Consult. In this tutorial, we will learn how to connect to relational data in the SQL Database from Power BI. Let’s get started.
The first thing we wants do is open Power BI
In the Power BI Desktop, click on Get Data drop-down and select SQL Server
In the SQL Server database, I am going to provide my Server and the particular Database where the table I want to connect to is stored.
In the caption of the dialogue box above, select Database on the right pane
Thereafter, I am going to provide my username and password
In the Navigator dialogue box, select Sales2017 table
Click on Load.
The table from SQL Server get’s loaded in the data model for further analysis