Category: Power BI

Power BI On-Premise Data Gateway Error: DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1

I got the following error DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1 This error was caused because the current Virtual machine where the On-Premise Data Gateway was running was cloned and then started up. The result was that this then caused the Power BI Service to not correctly connect to the valid Gateway. The reason is that there were 2 servers running, with the same name,…

Create Currency Formatting Strings using Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019

Below are the steps on how I got the calculation groups to work for Currency formatting strings when the currency format string will be displayed per currency shown. Following on from my previous blog post (How to create and use Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019) on how…

How to create and use Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019

I have been reading some great blog posts from SQLBI.COM on using and implementing Calculation Groups. What I did find is that currently there is not step by step process on how to get this working. This is what I will do in my blog post below. As it stands today 29 April 2020 you can currently use calculation groups…