cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect to Analytic Model in Power BI

Lora0121
Newcomer
0 Kudos
250

Hello,

 

I am importing a data source in SAP Datasphere with ODBC connector and using it in PBI.

I tried to use Analytic Model from datasphere in PBI.

But calculated and restricted measures created in Analytic Model are not displayed.

Only the fact tables are imported.

 

Is there a way to connect and use the Analytic Model in PBI?

Thanks in advance.

JulianJuraske
Participant
0 Kudos

Look at the help of SAP

https://help.sap.com/docs/SAP_DATASPHERE/43509d67b8b84e66a30851e832f66911/4db6f5a329af44509ae422ad70...

JulianJuraske_0-1728879477988.png



When using ODBC to 3rd Party the AM is not a supported Object, if you would use O-Data it would be possible:

JulianJuraske_1-1728879676648.png

You should overthink your own set limitation when you need to work with AM ;).

FYI:
I assume you still can see the AM because you can see / consume the relationale Table behind it, but not the Analytical Data:
https://help.sap.com/docs/SAP_DATASPHERE/43509d67b8b84e66a30851e832f66911/7a453609c8694b029493e7d87e...

Accepted Solutions (0)

Answers (0)