Power BI 14 blogposts

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.

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.

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.

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.

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?

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.

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.

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.

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.

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?