Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to connect to OData when data flow

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?

dataflow
Need Help

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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,

     

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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,

  • PBI-BOLA's avatar
    PBI-BOLA
    Frequent Visitor
    5 years ago

    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