Forum Discussion
Dynamic Column Headers in Table Visual Based on JSON Data
I have a table visual on a report page with multiple columns, one of which is QC ID. In the data model, QC ID is related to another fact table that contains a column in JSON format. This JSON column...
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.