topic Custom Visual Data Question in Developer

Custom Visual Data Question

cipherbear — Tue, 09 May 2017 18:05:29 GMT

Hey Guys,

I need to write a custom visualization for PowerBI, I understand that the main visualization is written in TypeScript, but I am more concerned with how the data is actually converted once you load it in to powerbi. I need to know what it is parsed in, XML, or JSON for example, so that I know how to work with it when writing my visualization. Any help is greatly appreciated.

Question Regarding Data Type

cipherbear — Tue, 09 May 2017 18:09:26 GMT

Hey Guys,

Re: Custom Visual Data Question

MawashiKid — Tue, 09 May 2017 20:05:57 GMT

You may have a look at my slideshare on Creating Custom Visuals with Power BI Visuals CLI [jump to slide 21...].

https://www.slideshare.net/DenysChamberland/creating-custom-visuals-with-power-bi-visuals-cli

In Power BI you can provide data in many format such as Excel, csv, sql query, json, ... but I'd say the main key to understand when creating a new pbi visual component is to understand how to map and convert those datas. For example, in case of liquidFillChart or Thermometer, you only need to pass a single value, so you'll use DataView Single pattern. In another case such as Sunburstchart, you may need a more elaborate pattern like DataView Matrix pattern. That is done through DataRole and DataView parameters in capabilities.json and then provide a converter function either in visual.ts or in converter utility interface. Hope this helps