SAP datasphere to PBI connection via OData

[soniaparvin9]

Hi,

I am following the below link to obtain data from SAP datasphere to power BI. Connection has been built I can see the spaces and assets but facing issue while obtaining the data step.

Link: https://community.sap.com/t5/technology-blogs-by-sap/connecting-sap-data-warehouse-cloud-odata-api-w...

Specifically while generating additional column after using the invoke function.

It is always showing error in each row of the new column:

Could you please help me how to resolve the issue, as we cannot see any data of any entity of Datasphere in PBI.

[uzuntasgokberk · Accepted solution]

Hello @soniaparvin9 ,

I haven't tried connecting SAP Datasphere to Power BI using OData. However, I have successfully connected SAP Datasphere to Power BI via ODBC, and it worked perfectly. For reference, please see the following link: SAP Datasphere to Power BI Tutorial.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |