Tuesday, July 9, 2019

Azure SQL Server - Configuring Connections with PowerBI

In this tutorial, we will learn "How to configure connections with Power BI" to connect with Azure SQL database or Azure SQL data warehouse from Azure SQL Server.

Note: If you don't have an Azure subscription, then create a free account before you begin.


You have to do followings-
1. Configure Client IP - We have to Add to the Allowed IP Addresses in set server firewall settings and where we can also add a range of IP addresses to allow.
2. Configure Connection String with access credentials - get the connection string to connect with.
3. Connect DbVisualizer with credentials with Azure 
4. Pull your data from database or data warehouse

Note: You don't use your Azure login ID to connect to the SQL service. You use the new credentials that are specific to the SQL database you've created via the Azure SQL Data Service console. Also, you must specify "encryptionMethod=SSL". Required for all communications with SQL Azure.

To learn more, please visit us at YouTube -

No comments:

Post a Comment

Popular Posts

Get Sponsored by Big Brands