Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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,
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |