Data is concatenated / aggregated if element appears multiple time in view / query
PowerConnect version 1.1.1 TM1 version: 11.8.02200.2
The data is concatenated / aggregated if elements appear multiple time in view / query
To reproduce
- Create a view with an element that appears multiple times. It could be the same element, or one that rolls up to multiple parents in the same hierarchy.
- Import the view to Power BI.
- You'll see the numeric values being aggregated and string values (and numeric attributes) concatenated.
This has the potential to happen if "All Members" are shown where there are multiple roll ups in a hierarchy.
I would expect either the rows to be duplicated as in the query (which could then be seen as an issue in Power BI (and could be put down as user error)), or the correct value for the distinct member would appear, not an aggregation /concatenation of the data.