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
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 (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)…
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…
Using Let’s Encrypt certificates for secure SQL Server connections
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,…
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…