Getting 500 Internal server error while publishing OData Feeds.

[manas_jani]

Hello Experts,

I am trying to load data using OData feeds in PowerBI while loading the data it gives an error message. 500 internal server error after discussing with my SAP Team I came to know that I have to pass parameters while reading this data into PowerBI and I am not aware if I can pass any parameters and filters with OData Feeds URL or not. I'd appreciate if someone from the community can help me with this problem and also attach an image of the error message. 

[Anonymous]

Hi @manas_jani ,

You can filter the products with a specific category by appending the query option like this:

https://services.odata.org/TripPinRESTierService/People?$filter=FirstName eq 'Scott'

Replace the URL with your actual OData feed URL and adjust the filter condition as needed.

Reference Services · OData - the Best Way to REST

You can try to verify the OData endpoint and check the authentication type you are using in the OData connector. Additionally, ensure that your OData service URL and other configurations are correct.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum