A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all the stock levels of your […]
Category: Power BI
Book Review – Power Pivot and Power BI
Since Power BI is all the rage right now, I was in need of some material to spice up my knowledge of DAX (read: finally understand how CALCULATE works). I’ve been following the website powerpivotpro.com for quite some time now and they always have very insightful articles about DAX and real world scenarios. Anyway, Rob Collie […]
First thoughts on Power BI on premises
The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises using Reporting Services! The preview itself is a VM hosted in Azure. You can read all about setting it up in the SSRS team blog post. I toyed around with the VM for a few […]
Power BI Desktop hosted on premises with SSRS 2016
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the SSRS Team blog. You can also find my first impressions of the preview in the blog post First thoughts on Power BI on premises. UPDATE 2017-05-08: you can find more information about the Power BI on […]
Slidedeck ITPROceed – Power BI Status Update
I uploaded my slidedeck from the ITPROceed event to Onedrive. For the abstract, see the blog post Speaking about Power BI @ ITPROceed 2016.
My first SQL Server 2016 POC
Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of course 🙂 One of the first things I noticed, is that installing SQL Server 2016 is quite fast. Installing the database engine, SSIS, SSAS and SSRS is just a matter of minutes. In contrast with […]
Conditional Formatting and Quick Calcs in Power BI Desktop
There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official announcement yet. However, two great new features have been spotted by Chris Webb: @marcorus a few things – quick calculations (only seen % shares) and conditional formatting in tables for example — Christopher Webb (@Technitrain) […]
Dynamic Security in Power BI
UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post. In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you can use this feature to implement dynamic security. In other words, the […]
Power BI Service error: “This visual has unrecognized fields”
UPDATE: IT SEEMS THE BUG HAS NOW BEEN FIXED. THREE HOORAYS FOR THE POWER BI TEAM! Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the […]
Power BI Confusion
Just a quick post on some Power BI material that I believe should reach as many people as possible. I get the notion there is a lot of confusion about what is possible in Power BI v2 and which features are supported in the free and in the paying version. (I gave a session on Power BI […]