Forum Discussion
Custom Visual Data Question
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.
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-cliIn 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
2 Replies
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-cliIn 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
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.
