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.


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


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


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

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

Using Let’s Encrypt certificates for secure SQL Server connections

Let's Encrypt

Since December last year, the Let’s Encrypt initiative has gone into public beta. Let’s Encrypt is a free, automated, and open certificate authority, so you can easily get free official SSL certificates. Primarily it is focused on securing the web, but the requested certificate can be used for every server authenticating. I uses the certificate to encrypt my SQL Server connection and of course use it for Reporting Service.

How does it works

Let’s Encrypt provides certificates that are valid for 90 days. This stimulates the use of tools and scripts as no administrator is reassigning a new certificate every 90 days for each server. primarily Let’s Encrypt is focused on (Linux/Apache) websites,

Continue Reading

Pushing data thru Azure Stream Analytics to Power BI - part 4

After 6 months there has been a lot of changes in the offering of Azure and Power BI. Those changes implies that my blogposts about connection Stream Analytics and Power BI (1, 2 and 3) are not completely the best and easiest way of doing this.

Power BI changes

It is still in preview, but Stream Analytics supports directly out of the box a connection to Power BI as an output. Stream Analytics only needs a valid authentication and a dataset name and a table name. If the dataset and/or table doesn’t exist, it will be created.


So in my case I don’t need a custom application anymore to pull the events from Stream Analytics and push

Continue Reading