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 Team,
We are using SAP Hana Calculation view as a source and it has a hierarchy available in it, but that is not visible in PowerBI even when I try to connect it as a cube in Direct Query.(I.e treat SAP Hana as a realtional Source disabled)
Any help/advice will be greatly appreciated.
Thank You,
Aslan
Solved! Go to Solution.
@Aslan-R,
Please check if you hit the following limitation.
1. Parent Child Hierarchies - Parent child hierarchies will not be visible in Power BI.
2.Other hierarchy metadata - The basic structure of hierarchies is displayed in Power BI, however some hierarchy metadata (such as controlling the behavior of ragged hierarchies) will have no effect.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana
Regards,
Lydia
@Aslan-R,
Please check if you hit the following limitation.
1. Parent Child Hierarchies - Parent child hierarchies will not be visible in Power BI.
2.Other hierarchy metadata - The basic structure of hierarchies is displayed in Power BI, however some hierarchy metadata (such as controlling the behavior of ragged hierarchies) will have no effect.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana
Regards,
Lydia
Hi Lydia,
Thanks for your response, I believe our's is Parent-Child Hierarchy and hence it is not getting displayed.
I will try other options and then see.
Thank You,
Aslan.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |