Forum Discussion

Frequent Visitor

10 years ago

Solved

Finanical Modeling Plugin for Power BI

Hi guys, I am currently doing research on how to transfer data models from SAP HANA & ECC to Power BI. We have some financial modeling built within SAP HANA & ECC, I am just wondering if there is any...

Need Help

v-sihou-msft
10 years ago
Layla

In POWER BI Desktop, you can select DirectQuery Mode when connecting to SAP HANA Database. It can load the relationships between tables automatically. But it can't do modeling when using DirectQuery mode. If you use "Import Data" mode, you can do some simple modeling like adding calculated column and measures, or manage the relationship manually. For more details, please see:

Use DirectQuery in Power BI Desktop

Use SAP HANA in Power BI Desktop

Regards,

v-sihou-msft

Microsoft Employee

10 years ago

Layla

In POWER BI Desktop, you can select DirectQuery Mode when connecting to SAP HANA Database. It can load the relationships between tables automatically. But it can't do modeling when using DirectQuery mode. If you use "Import Data" mode, you can do some simple modeling like adding calculated column and measures, or manage the relationship manually. For more details, please see:

Use DirectQuery in Power BI Desktop

Use SAP HANA in Power BI Desktop

Regards,