The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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