Unable to connect to OData when data flow

[Anonymous]

I'm trying to connect to OData.

However, I can't authenticate using either Anonymous, Basic, or Organization. Anonymous and Basic give me error A and Organization gives me error B:

Error A:

Error B

In scheduled refresh, I can normally connect to the URL Odata using WindowsWithoutImpersonation. But it looks like that's not even an option in the data flow. I can also connect to this url just fine in Desktop.

Does anyone have any ideas?

[PBI-BOLA]

UPDATE

02/Nov/2020

Figured out that the Dataflow function in the service doesn't appear to support "ODATAV4" sources. After amending my link to "ODATA" it worked as expected.

------------------------------------------------------------------------------------------------

Hi,

Was there a solution to this? I'm getting a similar issue

This is a connection to a NAV database. example of the link used is:

http://<Server>:<WebServicePort>/ODataV4/

I have also tried a direct connection to a specific company so

http://<Server>:<WebServicePort>/ODataV4/Company('CRONUS%20International%20Ltd.')/

No luck. 

@v-lid-msft your solution isn't what I'm looking for as the odata link is published online, shouldn't there be no need for a gateway? 

I can connect to the odata connection through PBI Desktop and published reports are able to refresh online without a gateway.

Thanks

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @Anonymous ,

Based on my test, if we want to use windows authentication with the odata in dataflow, we need to select an On-Premises data gateway for it. Have you tried  use Organiszation authentication or basic authentication to connect same OData in the Power BI Destop?

Best regards,