How to retrieve table data from Power BI desktop into custom visual?

[RichardL]

Hello, I've created a table with two columns named "X" and "Y" in Power BI Desktop.  Each column contains integers.  I also created a custom visual that I can import into Power BI Desktop.  Is there a way for me to read data from the X and Y columns into my custom visual using TypeScript only or do I need some sort of external library to do so?  Thanks.

[RichardL · Accepted solution]

I figured it out.  Had to modify capabilities.json and use DataViewMappings in my visual.ts file.

[mpo]

@RichardL

Could you post what you ended up with, by any chance? I think I have a similar problem and don't know how to access table data mapping values in visual.ts.

[RichardL]

First, I would read this introduction on DataView:  DataView Introduction

Also go over DataViewMappings here:  DataViewMappings

Then follow this great example:  Build Your Custom Visuals Power BI

I believe those three links above will set you on the right track.  Good luck.

[mpo]

I have seen first two links and didn't find them particularly helpful,

The third example though is great indeed - many thanks!

[RichardL]

Not a problem.  Documentation on how to retrieve table data from Power BI desktop is very sparse and difficult to find, to my surprise.  I tried searching for books on this to no avail.  Boo.

[adamdavi3s]

The third example got me started just fine, I was flailing around until I found that!

[v-chuncz-msft]

@RichardL,

Glad to hear that you've solved this problem and thank you for sharing the solution. You could mark it as answer so that other community members might gain benefits.

[RichardL]

Cake walk in the park 🙂