
Connect to a SQL Azure database with Power-BI
From time to time (yes it’s almost that time of the year again, when we use this opening statement)… user’s have difficulties to connect to a SQL Azure Database with Power-BI. So I decided to post this article as a brief hint (and as reminder for myself), how to connect from Power-BI. First of all, allow the connection with TCP port 1433 to your client IP address in the Azure portal at https://portal.azure.com. Click “Add client IP” and add it to the firewall settings of the SQL server as in this sample here. ...

