Power BI:How To Connect To Source Data Stored In SQL Database

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.

Click OK

In the caption of the dialogue box above, select Database on the right pane

Thereafter, I am going to provide my username and password

Click Connect

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


Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *