Forum Discussion
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 off the shelf financial modeling plugin for Power BI that we can build upon. If not, when I load all the data from SAP HANA &ECC, will the relationships between tables be uploaded as well?
Thanks in advance for your help!
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,
2 Replies
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,
Thank you, Simon!
