Forum Discussion
Dynamic Column Headers in Table Visual Based on JSON Data
In the image below, you'll need to add an index column to uniquely identify each row values in matrix are always aggregated.
Please see the attached pbix.
The link is the same as initially posted
In the image below, you'll need to add an index column to uniquely identify each row values in matrix are always aggregated.
Please see the attached pbix.
Thanks a lot danextian
It seems to be working and the only thing I want to check with you, in my actual data the details table has 1.3 Lakhs rows which further grew up to 39 Lakhs after the transformation.
Row count doesn't seem to be a big problem, the part which I am concerned of is, the transfomation step took almost 1.5 hrs to load the data after transformation.
Is this expected or can we improve on this?You have too big of a data. Ideally, these transformations should be done at the source.