Forum Discussion
Connecting to Azure SQL Database via Dataflows - authentication not working.
Go it, so the issue was:
I was using my own login for authentication in Dataflows - but, my login used Azure Active Directory for authenticaion, and Azure SQL Database doesn't support Azure Active Directory authentication.
Solution: Setup a new SQL Server user in Azure SQL Database, and connect via that login, using the 'Basic' Authentication option in Power Query.
Thanks. We did have [Allow Access to Azure Services] on already.
Do we need to specify the IP range that Dataflows uses? (Though isn't it completley dynamic / unpredictable?)
Hi mmace1 ,
Just try it. You can refer to this document: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-server-level-firewall-rule.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try what, adding the Dataflows IP address as a server-level firewall rule in the Azure SQL Database?
Isn't the Dataflows IP address dynamic?Hi mmace1 ,
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. However, the IP range of Power BI server is updated weekly. Moreover, it could be different each time within each region. So, you have to monitor and update the IP range on time to ensure Power BI can always fetch data successfully.
Reference: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication#ports.
If the issue is still there and you are a pro user, I suggest you to create a support ticket to get further help.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for confirming the IP addresses vary. That cofirm it woudln't be (to my way of thinking) a very solid solution then.
It seems as if Azure SQL Database doesn't support Azure Active Directory. At least, Azure SQL Datawarehouse doesn't, and I'm guessing maybe SQL Database is the same.
https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use
I'm going to try to get someone with the necessary permissions, to setup a SQL Server login, and see if that works for Dataflows.