How to connect to Analytic Model in Power BI

[Lora0121]

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]

Look at the help of SAP

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

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

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...