Category: Report Development

Strategies for Loading Your Data Incrementally

Strategies for Loading Your Data Incrementally

During your ETL, large amounts of data are loaded from a source into a target storage. As this is something that is often done multiple times a day, you want to optimize this process as much as possible to reduce load time and minimize costs. An incremental load is something that emerges quickly as a […]

Charticulator in Power BI

Charticulator in Power BI

Sometimes getting the right insights in your data is more complex than any already existing Power BI visual can offer. Maybe you want to display your own branding inside visuals? Or you just like to play around to create the most beautiful and unique visuals. Here, Charticulator enters the field. This open-source project by Microsoft […]

Power BI Deployment Options [Part 1]

Power BI Deployment Options [Part 1]

Ever wondered how software engineers are able to work in massive teams on the same project/code and get changes pushed to the end users at frightening speed and consistency? Wonder no more! In this series, I will explain all there is to know about Application Lifecycle Management when using Power BI. At the end of […]

Power BI: Paginated Reports

Power BI: Paginated Reports

One of the most valuable, yet less used functionalities of Power BI is ‘Paginated Reports’. This article will explain what they are, when you need to use them and how they can benefit your organisation. At the end, some samples can be downloaded that demo the functionality.  Starting-Off with an Example As you can see […]

DAX Pattern: Top X and Others

DAX Pattern: Top X and Others

As a Business Intelligence Consultant working with Power BI, I often get the following question: “Could you give me a top X of our highest selling products?” Of course the answer to this request is yes because that’s fairly easy to implement in Power BI. However, every once in a while we get the following […]

Keep those Power BI reports in (source) control!

Keep those Power BI reports in (source) control!

While self-service is an easy way of creating and changing existing reports, organizations may struggle with version control of the reports that are published to a Power BI service. We’ve often heard the sentence “Sh**, I’ve overwritten one of my important reports!”. Yes, this problem can also occur to experienced developers and even consultants of […]