Skip to main content

Developer APIs

Under Review

Power BI Data Visualization API

Vote (72) Share
Binh Cao's profile image

Binh Cao on 17 Feb 2015 05:39:19

Can we open up Power BI to allow other creative thinkers out there to create new visualizations that can be posted on Power BI dashboard? As long as they have certain parameters (Name, chart types (visualization types), input data, scale, whatever, etc.) they can call API that can draw that visual to be displayed in Power BI. This opens up creative ways to display data and allows Power BI to be extensive and flexible.

Administrator on 25 Sep 2015 08:44:28

Just dropping everyone a note here to make sure you've aware of our Best Visual contest http://aka.ms/powerbiviscontest. There's still time to enter (October 1st is the deadline). Lots of great entries so far, Even an Aquarium! We're making steady progress on this. Don't wait to learn how to build custom visuals that work in Power BI, your learning will pay dividends. If you've not seen it yet, we have open sourced the Power BI visuals, you can get them at www.github.com/Microsoft/PowerBI-visuals. We've announced that we will enable developers to build custom visuals for Power BI. You can see some more information here: powerbi.Microsoft.com/custom-visuals

Comments (8)
Binh Cao's profile image Profile Picture

Power BI User on 05 Jul 2020 22:03:38

RE: Power BI Data Visualization API

Are you really wearing google glasses?

Binh Cao's profile image Profile Picture

Binh Cao on 05 Jul 2020 22:02:22

RE: Power BI Data Visualization API

ha, this is great, my claim to fame with this idea :) finally, my rambling has been heard by somebody

I am proud

Binh Cao's profile image Profile Picture

Power BI User on 05 Jul 2020 22:02:06

RE: Power BI Data Visualization API

A lot more visualisations would be a start, but to put the power in the hands of developers would be huge. Something not unlike data bound controls in many other MS/non-MS products, almost certainly harnessing the flexibilty of JS/HTML5 for the display element.

I'd like a fairly simple grid structure to present multiple metrics with some RAG elements for performance movement and performance against targets. My exact requirements would probably be too specific to ever make the vertical strip of inbuilt visualisations, but if I could build one myself and feed it from a data set, that would be very powerful!

Binh Cao's profile image Profile Picture

Power BI User on 05 Jul 2020 22:01:42

RE: Power BI Data Visualization API

i also need something like this

Binh Cao's profile image Profile Picture

Mark Jones on 05 Jul 2020 22:01:34

RE: Power BI Data Visualization API

Being able to load in custom d3.js, or other custom libraries for visualizations would really take Power BI to the next level as a BI platform

Binh Cao's profile image Profile Picture

Peter Schmidt on 05 Jul 2020 21:58:59

RE: Power BI Data Visualization API

I would also like to see a few more visualisations added out-of-the box, especially bullet charts, box plots, dynamic sparklines (12 months rolling) and gantt charts. I have been using the excellent Sparklines for Excel add-in (http://sparklines-excel.blogspot.com.au/) but of course being Excel VBA they don't work with Excel Services. As a former student of Stephen Few I want to be able to create dashboards like those shown on the cover of his book (http://perceptualedge.com/library.php#Books) effortlessly.

Binh Cao's profile image Profile Picture

John Fitzpatrick on 05 Jul 2020 21:58:57

RE: Power BI Data Visualization API

In my mind, the single biggest disadvantage the Microsoft Power BI suite has is sticking users with basic excel charting capabilities. There are alternatives to excel for digging through information, but nothing that compares with the ease of use and power it provides to the standard users. However on the charting front, excel has been left behind. All you have to do is look at the examples of different visualizations on the d3.js website to see the capabilities of modern visualization tools.

If we were able to use external charting libraries available through github or other sources for publishing to dashboards it would provide users with the best of both worlds.

Binh Cao's profile image Profile Picture

Tony Gaul on 05 Jul 2020 21:57:03

RE: Power BI Data Visualization API

There are a few options here:

Using a similar model to Office Apps, allow custom charts apps and let the community do the development work (and allow devs to make money). Such as databurst / sunburst, Gantt, Waterfall, Infographic style charts

Allow something similar to custom Excel charts where you can create custom combinations & use report templates

Look at integrating with javascript libraries such as d3.js