cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fairnie
Frequent Visitor

Accessing data from dataViews[0].table as object

I am trying to create a Power BI version of this (bumbeishvili/org-chart: Highly customizable d3 org chart. Integrations available for Angular, React,...) 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. 

 
   
1 REPLY 1
fairnie
Frequent Visitor

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors