Hello,
I want to build a power bi dashboard that fetches data from A360 DB. Most precisely I want Power BI to fetch the data of the workitems processed.
I see that this data is contained under WORKITEMS table. However, if a queue has more than 10 columns, the data (presumably) needs to be queried from the ‘json’ column of this table: