Showing results for 
Search instead for 
Did you mean: 
New Member

Odata URL - SAP ECC and Power BI

Hi Community,


While performing the function - Get Data - from Power BI using the Odata feed URL, shown below, in Power BI, it shows the error code 500, Internal Server Error. This is a URL generated in SAP Gateway service, which will give the Odata feed from SAP ECC system.

http://<server name>:8000/sap/opu/odata/sap/ZSDSRN_ODATA_SRV_01/zsale_dataSet?sap-client=500


However the same URL works fine while executing it from the Internet Browser.


As we understand, the URL part "sap-client=500" at the end, may be not rightly be interpreted by Power BI Get data function.

Is there any other way for mentioning the same. This part of the URL identifies the client system to which SAP connection is to be made.


Your help would be appreciated.





Community Support
Community Support

Hi @SCIL ,


Because Odata feed is just a connector, we can't find out fully based on the 500 error. Please clear permission for the current data source and use Fiddler to trace log. (Fiddler Web Debugger Tool)  

Data source settings.PNGClear permissions.PNG


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

Helpful resources



We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors