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 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.
Hi mmace1 ,
Oh, I didn't notice this. It turned out that I was in the wrong direction. Anyway, wish you success.
Best Regards,
Icey
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.