In this Implementation phase, I will discuss how to integrate Microsoft Azure SQL database with Power BI desktop.
The tasks list for this section:
- Integration with Azure SQL database
- Data visualization in different graphical mode
Task 1: Integration with Azure SQL database
You need to install Power BI application system on your machine if you don’t have installed it. Download it from Microsoft Power BI website and install it on your computer. You need to open an account with your email address, that email ID must be similar to the Azure account.
Step 1: After opening your Power BI desktop application system, You will get “Get Data” option. Select “Azure” and Azure SQL Database, Click connect.
Step 2: Now provide your Azure SQL Server connecting string, database name for establishing connection. Data connectivity mode “Import”, click “Ok”.
Step 3: Now you need to navigator with the tables you want to import. You can select more than one tables for importing.
Step 4: It will take some time to fetch the data from Azure SQL to Power BI Application system.
Step 5: Now you can see your data is imported into Power BI and ready for further analyzing and data visualizations.
Thank you 🙂