MS SQL Azure with Power BI

Connecting through Power BI

Connect to the Azure SQL Database connector for Power BI.

1. Select Get Data at the bottom of the left navigation pane.
   
2. Within Databases, select Get.
   
3. Select Azure SQL Database > Connect.
   
4. Enter the necessary information to connect. The Finding Parameters section below shows where this data can be located in your Azure Portal.
   
   
   

   Note: The username will be a user that is defined in your Azure SQL Database instance.

5. After you've connected, you see a new dataset with the same name as the database you connected to, and a placeholder tile for the dataset, created on the dashboard.
   
6. Selecting the placeholder tile for the dataset opens a new report, where you can explore all of the tables and columns in your database. Selecting a column will send a query back to the source, dynamically creating your visual. These visuals can be saved in a new report, and pinned back to your dashboard.
   

Finding Parameter Values

Your fully qualified server name and database name can be found in the Azure Portal.