Power BI 9 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 - Optimising memory: how to merge tables

Johan Vermeire

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

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

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

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

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?  

Power BI: Styling and storytelling in reports and dashboards

Frank Bastien

Most Power BI users are impressed with the possibility to create custom visuals, which sometimes results in very colourful reports/dashboards – and occasionally even leads to documents that teeter on the edge between looking professional or amateurish. Where do you need to draw the line?

Power BI: Using multiple date fields

Frank Bastien

Like several similar solutions, Power BI works best if data are structured in a star schema, which is a structure that consists of fact and dimension tables. Typically, one of these dimensions is the date dimension. This dimension can filter your data based on calendar-type fields. If there are multiple Date fields in the fact table (such as OrderDate, DueDate, ShipDate…), there are some considerations to take into account.

Power BI: Row and filter context

Frank Bastien

As mentioned in earlier posts, Power BI uses an expression language called DAX (Data Analysis Expressions) to create calculations. At first glance, this language is similar to Excel formulas, but there are some important differences. Most importantly, DAX uses a row and filter context when executing expressions. 

Power BI: What is the difference between DAX and Excel formulas?

Frank Bastien

When you start using DAX, you might think that it looks strangely much like Excel formulas – but while they do look similar, they work in completely different ways. In order to execute calculations correctly, it’s important that you understand these differences.

Are you exploring Office 365 and do you have any questions about the software that need answering? Book one of our virtual workshops today. We’ll help you and your co-workers get up and running with Teams, Power BI, Power Automate, Project Online Professional, and other tools.

Discover the Office 365 workshops

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