Power BI 14 blogposts

If you’ve worked with Power BI before, you know that this package packs a punch. With Power BI, you can create visually appealing dashboards and reports and share them with your colleagues. Are you looking for tips and tricks about Power BI, written by our experts and based on their experiences with our clients? Read them here and baffle your colleagues and friends with your knowledge.

Power BI tip: Use folders to structure your measures

Johan Vermeire
28/09/2021

In many Power BI datasets, you’ll notice a separate table containing measures.  While this isn’t really necessary, it can be useful.

The downside is that as the number of measures grows, this table will be absolutely flooded with measures, which makes it hard to find the measure you need.

The usual solution for this problem is creating folders in the table... but at first sight, it looks like you can only create folders at the table level, not within the folders themselves.  It is possible, though - if you know how.

How to edit Power BI visuals as a user

Frank Bastien
10/06/2021

In most organisations, reports in Power BI and on other BI platforms are created by specialists in consultation with the person who requested the report. While these reports meet most expectations, there are situations where users need or want to have their data presented in a different way. They might want to include an additional perspective that wasn’t in the original report, for example.

This need is often temporary and doesn’t require the existing report to be changed.

To accommodate this, Power BI now offers users the option to change the way visuals are displayed. This option is called ‘Personalize Visuals’. The precursor to this option, ‘Decomposition Tree’, was similar in some ways. In this blog post, I’ll shed some light on both options.

Use custom tooltips to create interactive BI reports

Frank Bastien
02/06/2021

When you create a report in Power BI, you can use different kinds of visuals which are designed to let you analyse data from different perspectives. There are also several methods available to distil additional information from your data, such as drill-down, drill-through, and interactivity between visualisations.

Build your own Power BI reports based on existing data sets

Frank Bastien
26/05/2021

In many organisations, Power BI reports or data sets are created centrally. For reports, this means the organisation aims to create them with a standard setup.

Power BI is a ‘Self-Service BI’ platform, a solution that was developed to give any average user the means to build their own reports and gain insight into specific analyses or questions.  Of course, Power BI offers a ‘light’ version of BI, because not everyone is knowledgeable about BI or has experience with it.

One of the things you can do with Power BI is create reports based on existing data sets. Data sets are the foundation of a report: they contain one or several data sources that have been prepared for use in a data set where needed, as well as the necessary calculations for the analyses performed on these data.

Discover the advantages of the Azure Maps visual

Jeroen De Bruyne
16/04/2021

Power BI offers a range of beautiful visuals that help you present your data in an attractive way. Sometimes, this may lead to a choice overload: which visual fits your purpose best?

Power BI - Optimising memory: how to merge tables

Johan Vermeire
09/09/2019

In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. This blog post teaches you about merging tables.

Power BI - Optimising memory: how to split columns

Johan Vermeire
02/09/2019

In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. This blog posts teaches you how to split columns.

Power BI - How to optimise your memory: removing unneeded fields

Johan Vermeire
26/08/2019

In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. In this blog post I will tell you why you should remove some fields.

Power BI - Optimising memory: date tables

Johan Vermeire
19/08/2019

In our previous blog post, we explained how we can use VertiPaq Analyzer to analyse the amount of memory our model needs.  This memory is also linked to the speed with which the model calculates and refreshes data. In this blog series, we’ll discuss several ways to limit this memory usage.

Power BI – Check a model’s memory usage with VertiPaq Analyzer

Johan Vermeire
07/08/2019

One of the things you could do to refresh your data quicker and speed up calculations is resizing the data model. But how do you even figure out the current size of your data model? Is it the same as its file size?  

Bring your knowledge and skills to a higher level

Subscribe for our monthly newsletter and receive:

  • Exclusive tips & tricks
  • Information about our courses
  • Trends on courses
  • Invitations to seminars and events

Most popular courses