Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI doesn't allow connection with OAuth2 to SQL Source

Hi all,   I met frustrating problem recently for which I'm seeking a help:   The situation: I have a dataset in load regime with connection to a single source - SQL for which I use the Sql.Datab...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 

In Power BI Desktop, go to File > Option & Settings > Options, then check this box:

 

 

This will open the authentication window in a separate instance of your default browser, rather than failing in PBI.

 

Pete

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Helo Pete,

 

thank you for reply and suggestion. I used this options settings as you advised, however the actual sign-in is still skipped. When I select the account, this message shows up (with no password form or MFA action):

 

Although it looks like success, Power BI still shows error:

I tried again to use the same login to connect via SSMS and it works there just to be sure that my credentials are correct and was still able to see the database and the tables there, so there must be some problem between the Power BI and authentication service.

 

If you have any oter suggestions, please let me know.

 

Boris.

 

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    3 years ago

    Hi Boris,

     

    The only thing I can think might be the issue is the authentication method. Have you checked what method you're using to connect via SSMS and used the same method in PBI? It sounds like it should be Windows Authentication as the ssue started when you updated your password, but just check the type in SSMS and match it.

     

    Pete

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Pete,

       

      I'm using the Microsoft account (my corporate key ad we use Active Directory in Azure to manage user accesses in my organization).

       

      below the sign-in menus in SSMS (left) and Power BI desktop (right) to the same SQL server.  The SSMS asks me for the password and then for authentication in the mobile app, PBI doesn't do either of these and returns error (could not autheticate...). This is the same setup I used before the password change when the PBI used to connect correctly.

       

      I also tried to solve this with our helpdesk but they believe it is Power BI issue which they can't help with - as my access to the database as such works.

       

      Boris.

      • BA_Pete's avatar
        BA_Pete
        Icon for Super User rankSuper User
        3 years ago

         

        Did you try using Windows Auth in PBI instead?

        It may be worth asking your helpdesk to set up a database identity for you, if possible, so you can see if an alternative auth method works or not.

         

        Pete