Forum Discussion
How to connect to SAP Datasphere cube in Power BI
Hello,
I am importing a data source in SAP Datasphere with odbc connector and using it in powerbi.
Analytic Model (Cube) only shows the fact table.
Is there a way to connect to all of the data in the Analytic Model?
Thanks in advance.
Hi, Lora0121
To connect to SAP Datasphere's analytic model (Cube) in Power BI and access all your data, not just the fact tables, you can refer to the links below:
Datasphere to Power BI via an ODBC Connection - SAP Community
Consume Data in Power BI and Other Clients, Tools, and Apps via ODBC | SAP Help Portal
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AmiraBedh
Super User
You can start with this detailed tuto : https://developers.sap.com/tutorials/data-warehouse-cloud-bi7-connect-powerbi..html
Hi, Lora0121
To connect to SAP Datasphere's analytic model (Cube) in Power BI and access all your data, not just the fact tables, you can refer to the links below:
Datasphere to Power BI via an ODBC Connection - SAP Community
Consume Data in Power BI and Other Clients, Tools, and Apps via ODBC | SAP Help Portal
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
