Cannot connect to Azure SQL Database with oAuth2 in Powerbi Data Flow

[Anonymous]

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?

[v-lili6-msft]

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

[Anonymous]

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.

[v-lili6-msft]

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