Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I was trying to set up an entity in DataFlow by connecting to Azure SQL Database. However, the only option available is basic authentication. I can only connect to Azure SQL Database using Microsoft Account login. How do I connect to Azure SQL Database without oAuth2 options?
hi, @Anonymous
You could refer to this document:
https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with-direct-connect
Best Regards,
Lin
Are you suggesting that I change my Azure SQL DB data source from "Import" to "Direct Query" in order to use the oAuth connection? The link you send only mentions "Direct Query" and not "Import" mode.
HI, @Anonymous
I apologize for my carelessness, and I have tested on my side, it works well.
And if you could clear browser cache or use another browser to have a try?
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.