In the December 2020 release of Power BI Desktop, a long-awaited feature was added as a preview: small multiples (also known as trellis chart). A feature request for this chart type has been made since 2015! Small multiple charts are a set of charts of the same type on a grid, allowing you to easily […]
Tag: power bi
Speaking at SQLSaturday Vienna 2021
I’m thrilled to announce I’ve been selected to speak at SQLSaturday Vienna. Actually, it’s on Friday 15th of January, so don’t get fooled by the name. I’m bringing the session Self-service BI – Why Data Modelling Is Still Important, which is a beginner level talk about why you should pay attention to the data model […]
SUMX returns incorrect results with duplicates
Okay, the title of this blog post could also have been “SUMX returns unexpected results with duplicates”. The results only seem incorrect because an incorrect assumption might have been made. Let’s dive into the issue with an example. The Problem Suppose we have employees entering timesheet data. An employee can work on multiple projects in […]
Refresh Power BI Dataset using Logic Apps
A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows to easily refresh a specific dataset. This is good news, because in reality Azure Logic Apps are under the hood of Flow, so this means the refresh capability is now also available in Logic Apps. […]
What’s in the pipeline for Power BI?
If you’re interested in Power BI (or the Power platform in general), you might be interested in checking out the release overview guides of “2019 release wave 2” for these products: https://dynamics.microsoft.com/en-us/business-applications/product-updates/#overview-guides-and-videos Interesting stuff ahead! (I like they’re doing something with data lineage, which is about time)
Connect to Power BI Report Server with SSMS
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security role or modify an existing one. Recently I tried to log into our newly installed Power BI Report Server (March 2018 edition). I was greeted with the following error: The Reporting Services instance could not […]
Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel
As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data with Microsoft Power BI and Power Pivot for Excel by Marco Russo and Alberto Ferrari. The title is quite a mouthful but it gets the point across: the book mostly deals with how to correctly build […]
Excel Rendering In Power BI Report Server: You Are Not Licensed To Use This Feature
I recently migrated an SSRS 2017 instance to a Power BI Report Server environment, as you can read in the blog post Migrate SSRS 2017 to Power BI Report Server. After quite some issues, the PBI RS Portal worked and I could happily browse SSRS and Power BI Desktop reports. The last on the last […]
Migrate SSRS 2017 to Power BI Report Server
UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade working isn’t supported by Microsoft. However, someone from the SSRS team told me the March 2018 release of Power BI Report Server has fixed some bugs, so you should try to upgrade the normal way. […]
Data Modeling for Self-Service BI @ Techorama 2018
I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018 (the Internet is divided on the correct spelling: modelling or modeling. Apparently it depends on which side of the pond you’re on). Techorama is one of the biggest Microsoft-oriented tech events in Europe (it takes […]