OData Organization Account (OAuth) authentication not working on web service dataflow

[UAV-Test-Pilot]

I am trying to connect to a OData connection and authenticating via Organization Account (OAuth).  The authentication works just fine in desktop, but when in the web service the authentication fails.  The connection is to a sharepoint online site. I am in the GCCH enviornment.

Here is a screenshot from me trying to setup a new dataflow odata connection to the site.

My preliminary troublshooting shows that when I click "Sign In", I am redirected to the login url, but that url returns the error.
- URL: 

https://high.powerquery.microsoft.us/MashupEditor/oauthStartLogin.html?loginId=[info here]

Browsing to that url, and while monitoring the Network tab in chrome, shows that I get a status 500 error on this step "startlogin". Is this a microsoft issue, or an issue with my internal organization? Is there more troubleshooting I can do on my side?

[v-xicai · Accepted solution]

Hi @UAV-Test-Pilot ,

From your description, the OData connector works well, then you may go into the Advanced Editor in Query Editor and copy the code in Power BI Desktop. Then in the dataflow, create a new blank query and paste the code in there.

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum  to get further help.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[UAV-Test-Pilot]

I will open a support ticket to look into this issue further. Thanks