Nicky van Vroenhoven

Finance & Banking

Health & Medical

Microsoft Power BI sql server Microsoft Power platform Power Apps Power Query Power Automate (Flow) Power Platform Governance

's-Hertogenbosch, North Brabant, Netherlands

Nicky van Vroenhoven

Lead BI Developer

Nicky van Vroenhoven is a BI professional focused at the Microsoft stack and a Data Platform MVP. He mainly works with Power BI, Power Platform and T-SQL. After working 9 years in BI-consultancy jobs in several industries and companies, he is currently working as the Lead BI Developer and Power BI Administrator at the DWH team at Van Lanschot Kempen in The Netherlands.
Nicky has spoken at several User Groups, SQL Saturday Events, and the Power BI World Tour and is the co-founder of the Power BI Days Netherlands. In addition he enjoys tweeting and blogging about topics like Power BI and Power Platform at

Current sessions

Tips & Tricks of a Large Scale Power BI (Premium) Implementation

Attendees will walk away with guidelines and practical tips from a real-world implementation of Power BI (Premium) with 750+ users.
Back to September 2016: Power BI is new, shiny and hot. It is the tool of the moment, so people cannot wait to get their hands on it.
Fast forward 6 months, there is more traction within the business, trainings are given and workshops are held. The adoption of Power BI is growing. Some departments already use Power BI very extensively and incorporate it in their day-to-day processes. Due to this quick success there is uncertainty regarding the right support team for incidents and problems.
Because an app workspace creates an Office 365 group with a lot of artifacts behind the scenes, the creation workflow is controlled by IT. Unfortunately this inhibits the end users.
We require more governance, not to further bother the users, but it is essential to stay in control. Responsibilities need to be better aligned between IT and the business. And what to do with Power BI Premium?
Throughout this session we take you along on our Power BI journey, with tips, tricks, do's and don'ts during the implementation of Power BI (Premium) at a financial institute in the Netherlands.
For this session a basic knowledge of Power BI is assumed, there is no deep technical knowledge necessary.

This is a 45 min - one hour session (beginner - intermediate) that can be co-presented with my colleague Jeroen Schalken.

Query Folding in Power BI

Power Query allows you to extract and transform data from a variety of data sources. Have you ever experienced that the importing of data is slower than you expected? In most of those cases, query folding is not happening fully optimized.
Query folding is important because it offloads data transformations to the source, instead of performing them in Power BI.
Attend this session to learn how to ensure that you get all the performance improvements possible within your reports.
You will learn how to check if a query (really!) folds, how to use the Query Diagnostics feature, and even how to make a Native SQL query fold! As a bonus, you will also learn in which cases query folding is not your best friend.

This is an intermediate, one hour technical sessions. A basic understanding of Power BI Desktop is required because it goes under the cover into Power Query.

The Power BI Service - Workspaces & Apps

In this workshop we will go through a set of actions in the Power BI Service: publish to the service, manage access, create a dashboard, to publishing and maintaining an app.
As a bonus we'll go through some of the Power BI Tenant settings that are worth looking at as a Power BI Administrator.

60 minutes

A Form, a Flow and a Power BI Streaming Dataset Walk Into a Bar

This is a live demo session that demonstrates the Microsoft Power Platform of products working together to create an interactive data application.

It's good to have some form of interactivity in your presentation. Whether it's by (live) polling your audience, telling a story, asking questions during your presentation or any other way to make your presentation more interactive, doesn't really matter.
The way I started doing this was by firing some questions at the audience after I introduced myself. Although that worked pretty well, I was asking closed questions with a show of hands. I did get a feel of the audience from my perspective so I know on what topics to focus on a little more in my presentation.

But as I work with the Power Platform suite of products I thought it was a good idea to use some of that Power! So in this session I will show you the following:
- Create a form with Microsoft Forms,
- Create a Power Automate flow to get the answers,
- Push them into a Power BI streaming dataset,
- And finally create a Power BI report and dashboard on that dataset to get a live view of the answers of the audience.

Power Platform Better Together: Create a Scoring App with a Live Dashboard

Often during a presentation or workshop, you want to have an interactive quiz.
Maybe you've used Kahoot or any of the other platforms out there, but they rarely integrate well with our other applications. Using the Power Platform, we'll create an interactive quiz that gives you the best of all worlds.

Our goal is to create an app where attendees will answer questions and be awarded points for (partially) correct answers.
We want to have an application where we can enter the name of an attendee and their score. Ideally, we'll be showing the results using that application so there's no constant switching going on.
And, we're going to accomplish this by using 3 of the Power Platform products: Power Apps, Power Automate and Power BI.

Join this session to see how to build this solution from scratch!

Write-back with Power Apps in Power BI

Have you ever wondered why you can't edit your data in Power BI like in Excel? Now you can!
Well, not directly in Power BI, but you can accomplish this with a Power App inside a Power BI report.
In this session you will learn how to create a basic Power App and how to use that in the Power Apps visual in a Power BI report. You will learn how to connect Power BI and Power Apps together to update data in a database and display the results in Power BI.
During the session, we will also run through different use cases where this can be brought to practice.
This is an intermediate (Power BI) session, so experience with Power BI is assumed, prior experience with Power Apps is not necessarily needed.

Past and future events

Power BI Summit

18 Apr - 23 Apr 2021

Virtual Scottish Summit 2021

22 Feb - 27 Feb 2021

Power Platform Bootcamp Austria 2021

18 Feb 2021

PowerPlatform French Summit (2020)

18 Nov - 19 Nov 2020

M365 Chicago - Virtual Event

13 Nov 2020
Chicago, Illinois, United States

#DataWeekender #TheSQL

16 Oct 2020

Munich Power BI Days 2020-09-15

14 Sep 2020
Munich, Bavaria, Germany

Milano Power BI User Group

Power Platform Better Together: Create a Scoring App with a Live Dashboard
11 Jun 2020

Bangalore Power BI Days

A Form, a Flow and a Power BI Streaming Dataset Walk Into a Bar
19 May 2020

dataMinds Connect User Group

Query Folding in Power BI
18 May 2020

Data Community Weekender Europe

1 May 2020

SQL Saturday Iceland

CANCELED: A Form, a Flow and a Power BI Streaming Dataset Walk Into a Bar
28 Mar 2020
Reykjavík, Capital Region, Iceland

SQL Saturday Belgium

Tips & Tricks of a Power BI Implementation at a Financial Institute
7 Mar 2020
Mechelen, Flanders, Belgium

PowerPlatform World Tour

Tips and Tricks of a Power BI (Premium) Implementation at a Financial Institute
30 Oct - 31 Oct 2019
Dublin, Leinster, Ireland

dataMinds Connect 2019

6 Oct - 7 Oct 2019
Mechelen, Flanders, Belgium

SQL Saturday Prague

Power BI (Premium) Implementation at a Financial Institute
28 Sep 2019
Prague, Hlavní mÄ›sto Praha, Czechia

Belgium Power User Days 2019

13 Sep 2019

Power BI Gebruikersdag 2019

29 Mar 2019
Utrecht, Netherlands