Dataflows and Azure SQL DB

[Greg_Deckler]

Seems like something changed in terms of Azure SQL DB firewall rules. I thought in the past to allow the Power BI Service to access an Azure SQL DB you just toggled the "Allow access to Azure services" setting to "Yes". However, recently I was taking a look at this and this does not seem to work any longer, it is back to where you have to specify the actual IP address ranges of the Power BI Service to allow dataflows to connect and refresh data. Am I missing something? If it really back to specifying Power BI Service IP address ranges, where is the current list?

[Anonymous]

Hi @Greg_Deckler 

Has your problem been solved ? If it has been solved, provide your method for the problem then consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

[Anonymous]

Hi @Greg_Deckler 

I found a similar issue with yours . You can try to enable the access of Power BI not dataflow to Azure SQL via whitelisting the IP addresses, for your data region, in your firewall.

More info you can refer to the link :

https://community.powerbi.com/t5/Service/Connecting-to-Azure-SQL-Database-via-Dataflows-authenticati...

https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-create-server-level-portal-quicks... 

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @Greg_Deckler 

Do you see this in your Azure SQL under "Firewalls and virtual networks"?

[Greg_Deckler]

@GilbertQ Yep, and it was weird, was walking 2 different customers through dataflows and both had the "Allow Azure services..." toggled to "Yes". The first one still got an error that the Power BI Service couldn't connect to their Azure SQL DB and we had to plug in the IP address. The second one did not have to do this. So ?