3532736 - Error "The web page performed more than 20 redirects" when consuming Datasphere's OData service in Power BI

• Encountering difficulties while attempting to connect to the OData service of Datasphere from Power BI.
• The OData service provides data in the browser, but fails to connect from Power BI.
• Upon attempting to use the web option, the error message "The web page performed more than 20 redirects" is displayed.

• SAP Datasphere
• Microsoft Power BI

1. Open Power BI desktop.
2. Click on "Get Data".
3. Select "Web" or "OData"
4. Enter the Datasphere's OData URL.

Consumption of Datasphere's OData service is being performed in an unsupported approach/Data Source in Power BI.

The supported ways of Datasphere OData consumption in Power BI are listed in detailed here:

How to consume OData API in Power BI

• Community Blog Post Connecting SAP Data Warehouse Cloud OData API with Power BI via a Blank Query
• Community Blog Post SAP Datasphere: OData Connector for Power BI
• Help Consume Data via the OData API

OData, Datasphere, Power BI, connection, redirect error, web option, get data, PBI, PowerBI , KBA , DS-BB-ODATA , To address issues related to Odata consumption API , Known Error