Issue Connecting Power BI to SAP CDS View via OData Feed

[taher123]

Hi everyone,

I'm trying to connect Power BI to a CDS View in SAP using the OData feed. I’ve created the CDS view and exposed it as an OData service. I copied the OData service URL and used it in Power BI (via Get Data > OData Feed), but I’m encountering the error shown in the screenshot below.

Has anyone faced this issue before? What could be the cause and how can I fix it?

[SudheerKumarCH]

Hi @taher123 ,

The Power BI error message basically means the OData feed from SAP isn’t authenticating with the credentials you’re giving it.
Here’s how to troubleshoot and what you can reply on the forum:

Likely Causes

1. Anonymous Access Blocked:
   SAP OData services (especially CDS-based) don’t allow anonymous access by default. Power BI is trying with “Anonymous” mode.

2. Wrong Authentication Method in Power BI:
   You need to use either Basic (username/password) or Organizational Account (SAML/SSO) depending on how your Gateway is configured.

3. No HTTPS / Self-Signed Certificate Issue:
   Your URL is using HTTP on port 18020. Power BI may reject or require manual approval for an untrusted endpoint. So try https host. Check with your SAP BASIS team to get the correct https URL.

4. Missing CORS or Network Reachability:
   Power BI desktop must reach your SAP Gateway host and port. Check firewall / VPN access. Check this with your SAP and network team.
   
   Regards,
   Sudheer.