Forum Discussion
Connection to SAP S4HANA Analytics CDS views
Hi all. I´m trying to connect Power BI desktop with our SAP S4HANA server, using CDS views (Core Data Services). This is the new embedded BW, with realtime views of the database. CDS views are wo...
EduOtero,
Based on your description, you consume the CDS view data via the SAP Analysis for Office add-in in Excel.
In Power BI Desktop, I am afraid that it doesn't support to directly import data from CDS view using SAP BW APPlication Server connector. However, as per my reserach, CDS Views can be easily exposed as oData Service(API) which can then be utilized to fetch data out from SAP S/4HANA Cloud.
You can use OData feed connector in Power BI Desktop to connect to import data from CDS view.
Reference:
https://blogs.sap.com/2018/01/23/create-cds-views-in-sap-s4hana-cloud-and-consume-them-as-apis/
http://tiven.wang/articles/cds-to-odata-for-analytics/
Regards,
Lydia