Connecting Power BI to SAP System via OData – Access and Setup Guidance Needed

[Dhrutivyasa-070]

Hello Power BI Community,

I am working on integrating SAP data into Power BI using OData services. I would appreciate guidance on the following:

• Access Requirements:

  • What roles or authorizations are needed in the SAP system to enable access to OData services for Power BI?
  • Are there specific permissions required for reading data from OData endpoints?

• OData Connection Setup:

  • How do I configure Power BI to connect to these OData services (e.g., authentication, URL format, etc.)?
  • What is the recommended approach for configuring Power BI to connect to these OData services (e.g., URL format, authentication, etc.)?
  • Are there specific configurations, connections, or middleware tools required to enable seamless cross-server OData communication?

I am relatively new to this integration and would appreciate any detailed steps or resources you can share to get started.

Thank you in advance for your help!

Best regards,

Dhruti Vyasa

#SAPBI

#odata

#needhelp

[Dhrutivyasa-070]

Hi Power BI Community,

We are working with a development SAP system that has multiple clients (client 100 and client 500).

While trying to connect to the OData service for client 500 using the following URL, we notice that it defaults to client 100 instead:

https://<SAPServer>/sap/opu/odata/sap/FCLM_CASH_FLOW_ANALYZER_SRV$format=xml&sap-client=500

We need to ensure the connection specifically targets client 500.

but it always shows invalid credentials error. thogh i have all access.

Could anyone suggest how to set the client number in the OData URL or within Power BI? Is there a way to configure this properly to avoid redirection to the wrong client?

Any guidance would be greatly appreciated!

Thanks in advance!

[Anonymous]

Hi  @Dhrutivyasa-070 ,

The user needs to be a project member with Basic access, SAP Gateway is responsible for handling the OData service, the user needs roles that allow them to access and use SAP Gateway, you can check below link Assigning Roles to Provide Authorization for ODATA:

Understanding Authorization in OData - SAP Community

For the steps related to linking OData from Power BI, you can check the link below and enter the URL address in the text box, this URL should be the root of the OData service to which you want to connect. For example, enter http://services.odata.org/V4/northwind/northwind.svc/:

Connect with data by using OData queries - Azure DevOps | Microsoft Learn

Connecting Microsoft Power BI to SAP data - SAP Community

Power Query OData Feed connector - Power Query | Microsoft Learn

Best Regards,

Liu Yang

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