Accessing data from dataViews[0].table as object

fairnie — Tue, 08 Nov 2022 12:59:50 GMT

I am trying to create a Power BI version of this (bumbeishvili/org-chart: Highly customizable d3 org chart. Integrations available for Angular, React, Vue (github.com)) after many false starts and errors I am almost there I just can't bind the data in a way that the visual will accept. I can pass in data as a hardcoded object which will generate the visual.
I have followed this (Using the `table` DataViewMapping in Power BI Custom Visuals | coacervo) and can access the data view in visual.ts with "options.dataViews[0].table.rows"

as an array of arrays but I am not sure how I can manipulate it so that it is extracted in this format for the visual:
var data = [{id:'1',parentId:''},
{id:'2',parentId:'1'}]
The array just has the columns named as 0 and 1 but I want to name the array items as id and parentId and then pass this as an object but I am not sure how to manipulate the array.

Re: Accessing data from dataViews[0].table as object

fairnie — Wed, 09 Nov 2022 09:25:26 GMT

I found my answer: Solved: Re: Field order change issue when using options.da... - Microsoft Power BI Community

topic Accessing data from dataViews[0].table as object in Custom Visuals Development Discussion

Accessing data from dataViews[0].table as object

Re: Accessing data from dataViews[0].table as object