Connecting Power BI to Azure SQL

Greg Timms 1 Reputation point
2022-03-23T06:04:18.113+00:00

When exposing Azure SQL server to Power Bi there are 3 options. Option 1 - (No Gateway / Public Network Access) which exposes all azure services to the SQL server end point. If we were to utilize the whitelist option, our understanding is Power Bi platform currently uses dynamic ip addresses. Is there a MASTER IP list/location where these reside and how often do IP addresses changed?

Does Microsoft send alerts to any changes to this list. How do other customers manage this? Such as automated scripts to update the allowed IPs on the SQL server. Can Dynamics CRM communicate with Azure SQL server using option 1 with whitelisting. Are there any drawbacks or restriction we should be aware off?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,388 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 426.2K Reputation points MVP
    2022-03-23T12:46:03.593+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments No comments