topic Re: How to retrieve table data from Power BI desktop into custom visual? in Developer

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

RichardL — Thu, 29 Sep 2016 22:31:44 GMT

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.

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

RichardL — Fri, 30 Sep 2016 18:53:56 GMT

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

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

RichardL — Fri, 30 Sep 2016 18:56:26 GMT

Cake walk in the park 🙂

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

v-chuncz-msft — Mon, 03 Oct 2016 09:27:16 GMT

@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.

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

mpo — Mon, 03 Oct 2016 13:02:35 GMT

@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.

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

RichardL — Mon, 03 Oct 2016 17:27:39 GMT

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.

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

mpo — Tue, 04 Oct 2016 11:15:41 GMT

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

The third example though is great indeed - many thanks!

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

adamdavi3s — Tue, 04 Oct 2016 11:58:54 GMT

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

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

RichardL — Tue, 04 Oct 2016 17:16:32 GMT

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.