How to connect Power BI to Azure SQL database

How to connect Power BI to Azure SQL database

In this Azure tutorial, we will discuss how to connect Power BI to Azure SQL database.

How to connect Power BI to Azure SQL database

Well, before discussing the actual topic, let’s discuss the prerequisites needed to connect Azure SQL database with Power BI.

Prerequisites

Below are the Prerequisites needed here.

Assuming you are ready with all the Prerequisites needed here, let’s discuss the actual functionality.

Follow the below steps

  1. Open the Power BI Desktop app and sign in with your organization or school account.
  2. Click on the Get data link from the left side.
how to connect azure sql database to power bi

3. Search for Azure SQL Database, select the search result Azure SQL database –> Click on the Connect button.

Connect azure sql database to power bi

4. Specify the name of the server, Select the Data Connectivity mode and then click on the Ok button.

connect Power BI to Azure SQL database

5. Click on Sign in as different user button and provide the credentials and then click on the Connect button.

connect power bi to azure sql

You may come across the below errors while connecting from Power BI Desktop application to Azure SQL database and you will find the fixes for the same by clicking on the individual links.

Wrapping Up

In this article, we discussed how to connect Power BI to Azure SQL database. Thanks for reading this article !!!