Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data Source Credential error upon using OAuth 2.0 to Refresh Kusto data

I made a powerbi report that I published to the service with success. 

To schedule refresh on Power BI service, I use OAuth2. When I enter my credentials, I get two errors:

 1.  You need to use SSL (HTTPS) when you use OAuth 2.0 authentication.         

 2.  Message: AADSTS90015: Requested query string is too long. 

 

Everything works great on Power BI Desktop. 

 

 

  • Hi Anonymous,

     

    Did you notice that I used a Kusto connector while you used a Web connector? Please try again with the Kusto connector. Please refer to the snapshot below.

    Data-Source-Credential-error-upon-using-OAuth-2-0-to-Refresh-Kusto-data

     

    Best Regards,
    Dale

5 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Anonymous,

     

    I set it up and refreshed successfully. I would suggest you make changes to your data source as the error message guided. The connection string could be like this: https://kkkkkkk.kusto.kkkkkk.net:443. The point is 443, which means the connection is encrypted.

    Data-Source-Credential-error-upon-using-OAuth-2-0-to-Refresh-Kusto-data

     

    Best Regards,
    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

       

      what type of changes should I make? I don't really understand your recommendation.

      this is my connection string : https://kkkkkkk.kusto.kkkkkk.net:443/v1/rest/query?db/kkkkkkkkkkk&csl=.show version.

       

       

      This is the error I get when i try to edit credentials. 

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi Anonymous,

         

        Did you notice that I used a Kusto connector while you used a Web connector? Please try again with the Kusto connector. Please refer to the snapshot below.

        Data-Source-Credential-error-upon-using-OAuth-2-0-to-Refresh-Kusto-data

         

        Best Regards,
        Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

    Best Regards,

    Dale

  • I was coming across the message “You need to use SSL (HTTPS) when you use OAuth 2.0 authentication”. I resolved the issue by following these steps:

    1. Make sure that your browser allows pop-ups.
    2. If you're not using Microsoft Edge and the error persists after enabling pop-ups, consider switching to Microsoft Edge.

    I found this helpful checklist here: link.