Power BI SQL Server Connection

Written By Bear

Create SQL Query

We will connect Power BI to Sql Server Management Studio so that we can run a power bi sql server direct query.

First we will make sure our sql query data returns correctly in sql server management studio.

image1.png

Add SQL Direct Query to Power BI

Next will open Power BI and we can choose “Get Data” in the welcome screen.

image2.png

You will then come to a window with all the data options and you can choose “SQL Server database”

image3.png

If you close either of the first two windows without selecting SQL Server you still have two other ways of starting your connection.

First, You can choose SQL Server from the home menu.

image4.png

The other option is to choose SQL Server from the “Get data” menu option.

image5.png

Once you are in your connection window enter in your Database Server and Database name.  Then select “DirectQuery” as your Data Connectivity mode

Add your SQL Query Statement. Click OK

image6.png

Check your SQL query data

Your data from your query should show on the next screen. Click Load

image7.png

All your query fields should display in the “Fields” window. You can now use the data for reporting

image8.png

Power BI Tutorial

Bear
Previous

Dashboards