Power BI specialist in Utrecht

By handling everything behind the figures the team checks each morning: a model that brings together data from your systems, a refresh that finishes on time, alerts when a threshold is crossed and role-based access. If you’re looking for a Power BI consultant or Power BI expert in Utrecht, this is the work they do.

You can read about our general approach, regardless of region or sector, on our Power BI consultant page. If you work in Rijnmond or the Drechtsteden, see Power BI specialist Rotterdam.

Microsoft defines a dashboard as a single page of tiles pinned from reports. Those tiles can come from multiple reports and semantic models. A report has one or more pages based on a single semantic model, where you can filter and drill down. You create dashboards in the Power BI service, not in Power BI Desktop.

For a morning meeting, the distinction is practical: the dashboard shows the few figures you use to make decisions, while the report behind it provides the details. Read how we build a dashboard around the decision it supports on our Power BI dashboards page.

According to Microsoft, you can schedule up to eight refreshes per day on shared capacity. On Premium, Premium Per User or Fabric capacity, you can schedule up to 48. A manual refresh using Refresh now does not count towards the eight.

With DirectQuery, Power BI does not load the data into the model. Dashboard tiles then refresh approximately every hour, and a report page can refresh automatically. If a data source is on your own network, the refresh runs through an on-premises data gateway.

With an alert on a dashboard tile. You can only set one on a tile pinned from a report, and only if it is a gauge, KPI or card showing a number. The notification appears in the notification centre and, if you choose, by email and in the mobile app. An alert only works with data that is refreshed.

If you’d rather receive a summary at a set time, you can set up a subscription: hourly, daily, weekly, monthly or after a refresh. Take care with row-level security: the image in that email shows the data as the subscription owner sees it.

Yes. This is called row-level security: you define roles in the model using a DAX filter on the branch column, then assign those roles to users or a security group in Entra. A Microsoft 365 group will not work for this.

Note that Microsoft only applies the filter to people with the Viewer role in the workspace. Colleagues with the Admin, Member or Contributor role can see all rows. If you have teams in both Utrecht and Amersfoort, check each branch role using Test as role in the service before the teams open the report.

We’re developing a real-time dashboard with DutchSail for coaches in its sailing simulator, and a tool for Van Amersfoort Racing to track and compare young drivers. These are examples of what we build; DutchSail is based in Scheveningen and Van Amersfoort Racing in Zeewolde, and neither case study mentions Power BI.

We’re based in Amsterdam and can come to Utrecht or Amersfoort for a meeting; we can also meet online. You can read about our work with administrators and healthcare in Utrecht on our AI consultant Utrecht page.

No. The Utrecht Monitor is a product of the Research & Advice department of the municipality of Utrecht. It brings together data from sources including the residents’ panel and municipal and national records, and many of its figures are also available in the Utrecht in Cijfers database. A monitor like this looks back over a period of time.

An operational dashboard supports the next decision: which team goes where, and which backlog needs attention today. That requires a regular refresh and an owner for each figure. Both can draw on the same model, with definitions suited to each purpose.

When you discuss a figure once a month and the report from your ERP or planning system is sufficient. Or when departments disagree about what a figure means: a new screen will do little to help, and you should start with data governance.

If you mainly need extra people in your own BI team for a defined period, bringing in a BI consultant is a better fit than a project with a defined deliverable.