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 […]
Category: Report Development
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 Aggregations
Have you ever worked with a large Power BI report that’s just very slow to load? You’ve tried tweaking the model to improve the performance but without any luck. Then maybe aggregations is something to look into. Using aggregations, you can store the values of a (large) table aggregated by, for example, a date, a […]
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
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
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!
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 […]