Power BI Connector for CBS Open Data / Statline
Updated 7/10/2018: path updated below and new file on GitHub. Since this post primarily concerns a Dutch data source, the rest of this post will be in Dutch. English summary below. De open data die het Centraal…
Microsoft’s Language Understanding Service now speaks Dutch
Over the weekend Microsoft’s Language Understanding Service (LUIS) which is part of the Cognitive Services and the Cortana Intelligence Suite was updated to support the Dutch (Nederlands) language! Great news for anyone who needs to support Dutch…
Implementing incremental data load using Azure Data Factory
Azure Data Factory is a fully managed data processing solution offered in Azure. It connects to many sources, both in the cloud as well as on-premises. One of the basic tasks it can do is copying data…
Dutch elections analyzed in Power BI
Just in time for the elections in the Netherlands: I made an analysis using Power BI of the results of the elections since 1918. It is published (in Dutch) on the official Microsoft the Netherlands blog: https://blogs.microsoft.nl/technologieenmaatschappij/tweede-kamerverkiezingen-technologie-brengt-uitslagen-tot-leven/.…
SQL Server news from connect start to resonate
Hi all, A month ago at the Connect event in New York Microsoft did some anouncements on SQL Server vNext and Azure Data Services. It’s good to see the traction it’s getting! I work with a lot…
Annual radio countdown Top 2000 in Power BI
Full screen Most of this post will be in Dutch. Every year a list of 2000 songs is voted on by people from the Netherlands. This list is then broadcast by Radio 2 in the last days…
Passing filters to Power BI reports using the URL / query string
It was only recently that I discovered this – you can pass filters to Power BI reports by deep linking to it and adding a filter in the URL (also called query string). I am not even…
Power BI Custom Visual Development Tip: VisualPlugin.ts: Property ‘Visual’ does not exist error
So here you are, creating your very own Power BI custom visual. You have read the documentation and ran the tutorial (https://github.com/Microsoft/PowerBI-visuals/blob/master/Readme.md and https://github.com/Microsoft/PowerBI-visuals-sampleBarChart). You feel proud because you are done creating your awesome looking 3d-piechart-barchart-mashup visual.…
First look: Esri ArcGIS Maps in Power BI
Esri is a leader in the GIS industry and ArcGIS is a very popular product to build great maps. Now, you can use ArcGIS maps in Power BI (in preview). See the official information here: https://powerbi.microsoft.com/en-us/blog/announcing-arcgis-maps-for-power-bi-by-esri-preview/. This…
Adding sequence numbers using R in Azure ML
When going through data preparation sometimes sequence numbers need to be added. If you are like me, you probably spent some time looking for a component in Azure ML to do this. I never found it. Turns…
Data Nerdiness