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

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

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.

image

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

Continue Reading

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


Note: see this article for some new insights.

After the first two parts (1, 2) now it is time to look at the code to push data to the event hub and process the data from the event hub and push it to the Power BI API. Initially my idea is to use the Microsoft Band sensor to be pushed to Power BI, so I use for that purpose a HeartBeat class as records to be pushed.

Basically we need to code the following steps:

Sending data to event hub

image Before we can send data to an Azure event

Continue Reading