VSCode extension for Power BI Custom Visuals


Visual Studio Code Extension

This Visual Studio Code extension adds the option to directly start and restart the PowerBI Visual tools (pbiviz)
for developing Power BI Custom Visuals.

Features

Add 'build-in' support for pbiviz in Visual Studio Code.

  • Ctrl+F8: Start pbiviz and load the Power BI Custom Visual
  • Crtl+Shift+F8: Restart pbiviz and reload the new Power BI Custom Visual code
  • Ctrl+F9: Stop pbiviz

History

0.0.5 (December 5, 2016)

  • [Bug] Fixed that every restart created a new outout window 'PBIViz Cli Control'
  • Layout output window improved

0.0.4 (August 25, 2016)

  • Added 'pbiviz package' command
  • Added 'pbiviz update' command
  • Reduce output window pop-up

0.0.3 (August 6, 2016)

  • [Bug] Fixed restart sequence to

Continue Reading

Power BI visuals delivered via Azure CDN


Introduction

Power BI has the ability to import custom visuals and use them in your reports and dashboards. This is a great option to extent the visual capabilities of Power BI without waiting before Microsoft is adding that visual capability. Even Microsoft has created a gallery of 'approved' visuals to be used with Power BI. First there visuals were uploaded and stored within the report, but this has recently changed with the introduction of the Azure CDN capabilities.

Azure CDN

Azure CDN (content delivery network) provided a distributed network with nodes all over the world and is able to distribute website content faster to users all over the world. All CDN nodes has it own storage to serve certain (static)

Continue Reading

Power BI Hierarchy slicer


Hierarchy Slicer

Hierarchy slicer

The hierarchy slicer for Power BI provides the opportunity to simple select multiple members of different levels of a hierarchy as selection. The slicer can be used with an existing hierarchy or a manual created hierarchy.

Example

See here for an example if the embedded version is not working.

Changelog

See for the list of changes here.

Future

The following things are on the to-do list for a future release. The list is in a random order and sure not complete.

  • [0.7.4] Expand / collapse levels
  • [0.7.4] Style font size / color and background of items and header
  • [0.7.4] Support for auto-created Power BI hierarchies, like date fields
  • [0.7.4] Support for multi-select

Continue Reading

Changelog Hierarchy Slicer


Hierarchy Slicer changelog

Of the hierarchy slicer Power BI custom visualization the following versions are released with the following new features, changes and bug fixes.

NOTE: All Power BI gallery visuals are distributed via the Azure CDN network and this will cause a delay of max a couple of days in delivering a new version.

0.8.x - (in development)

  • Show/hide header
  • More formatting option
  • Show/hide '(blank) levels ('Ragged' hierarchies)
  • Auto-create hierarchy out of DAX PATH fields

0.7.9 - (24 August 2016)

  • Adding search support
  • Configurable selected item font color
  • [Bug] Expand/collapse fixed in IE11
  • [Bug] Filter selection saves with report

0.7.4 - (19 July 2016)

  • Expand and collapse hierarchy levels

Continue Reading

Managing Azure credits with Power BI


Recently I ran out of Azure credits before the new billing month was started. The result: Azure automatically disables the account and none of my resources were available. Next question was: how can I use Power BI to keep track of my credits? Can I Power BI help me in managing my Azure credits?

Azure Management API

With powerbi.com there is a content pack related to Azure, but it creates an operational dashboard and there are no spending reported. So I had to create it myself. Luckily a lot of Azure resources/services are available via different REST APIs. The Azure Resource Manager REST API was my first try. Is provides access to resources available within a subscription. But

Continue Reading