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…
Power BI learning resources – follow up 3
Another great resource for learning about Power BI is the course on EDX: Analyzing and Visualizing Data with Power BI. Granted, has been around for a while, but I forgot blogging about it; maybe it is a…
Power BI Refresh scenarios against data storage solutions explained
A recurring theme with customers and partners is Power BI data refresh. More specifically, there is some confusion on what refresh scenario requires a Pro version and what can be done with the Free version of Power BI.…
Data Nerdiness