How to connect to SAP Datasphere cube in Power BI

[Lora0121]

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.

[Anonymous · Accepted solution]

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.

[AmiraBedh]

You can start with this detailed tuto : https://developers.sap.com/tutorials/data-warehouse-cloud-bi7-connect-powerbi..html