Power BI Desktop issues with OAuth and OData Feed

[shreekar_pujari]

I am trying to connect to Organization OData service from Power BI using custom connector for OAuth authentication.

The service returns the data when I use Web.Contents(url) in the custom connector-- url being the endpoint for odata service.

But when I try to access the same service using OData.Feed(url) i get the following error,

OData: Request failed (404): The remote server returned an error: (404) Not Found. ()

I am not getting why OData.Feed doesn't work when the same endpoint works with Web.Contents

I have referred this link and tried whatever is mentioned, but it didn't resolve the problem.

Any help?

[shreekar_pujari]

Hi Rico Zhou,

The OData url isn't too long(less than 100 chars), also the number of columns returned ranges from 3 to 12-15.

As for the the web connector it is working, but I want to understand why OData Feed isn't working for an OData Service.

Regards,

Shreekar

[Anonymous]

Hi @shreekar_pujari 

Please refer to the offical blog as below and try again.

For reference: OData Feed

Best Regards,
Rico Zhou

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

[Anonymous]

Hi @shreekar_pujari 

Based on my research,  the above error could occur when OData URL string is large or large number of columns are pulled into Power BI Desktop. Please check your URL and try to reduce columns, then check if the error goes away.

And you can try to connect to the URL by Web connector in Power BI Directly.

For reference: Connect to webpages from Power BI Desktop

Best Regards,
Rico Zhou

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