Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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?

Dataflow

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-lili6-msft
        Community Support
        7 years ago

        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