Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User
Welcome to the first in my blog post series on evaluating the different aspects when looking to migrate from Azure Analysis Services (AAS) to Power BI Premium Per User (PPU). Apologies for this taking a few extra weeks to get started, life has been super busy, but as they say “Better late than never”. In this post I am going…
Incredible Power BI Announcements at Microsoft Business Applications Summit 2021
As I have done each and every year I go through and give an overview of all the Power BI Announcements at the Microsoft Business Applications Summit 2021. This year once again they have announced some incredible features either available now or coming soon so, please read below. Here are the links to the videos which have got more details…
Migration from Azure Analysis Services to Power BI Premium Per User – Series Intro
I have been doing a lot of evaluation and investigations for organizations who currently are using Azure Analysis Services (AAS) and looking to see if they can leverage Power BI Premium Per User (PPU) In this series I am going to cover the following details below, which I completed to see if the migration was not only feasible but should…
How to update or create a measure to Power BI Premium Per user without having to publish entire dataset
Following on from my previous blog post How to complete granular deployment of Power BI Desktop changes to the Power BI Service (Using PPU), I want to also show how to update or create a measure in my dataset, where I can deploy this via ALM Toolkit. This now saves me from doing the following tasks previously: Time taken to…
How to complete granular deployment of Power BI Desktop changes to the Power BI Service (Using PPU)
Now that we have got Power BI Premium per User (PPU), this opens a whole host of new capabilities. In this blog post I am going to demonstrate how to make a granular deployment where I will create a new column in my City table, and only deploy those changes. What this means is that by deploying only the column…
How to get an App feature on the Power BI Home page and in users Apps
There have been some recent updates to the Power BI Service that allow for certified Apps to be features in the Home section. Along with this, there is now the capability for your App to feature first when users view the Apps that they have access to in the Power BI Service. In this blog post I am going to…
How to get multiple slicer items filtered using the DAX TREATAS function
Quite often I wanted to get the data a slicer quickly and easily where multiple items are selected. I then wanted to use the slicer items to filter my measure. The first thing that I did was to manually hard code the values to make sure that I was getting the correct values with the following measure below. EVALUATE ROW…
Power Query – Remove all characters before delimiter & after delimiter
Below is the Power Query Syntax where I wanted to move the characters before the delimiter. I must give credit to the Power BI Community who got me going with how to solve this. For reference: Solved: Rename all column headers removing part before to … – Microsoft Power BI Community This is an example of what my column name…
Configure OLS in Power BI using Tabular Editor to limit access to non-financial measures
What Object Level Security (OLS) allows me to do, is to define which tables or columns users can or cannot see. My example which I am going to detail below will show you how I will restrict a user from viewing sales data. The same user will be able to see Quantity amounts. This becomes really powerful because not all…
Power Query – Continuous Week on Week Comparison
Below is the Power Query syntax to allow for Week-on-Week comparison over multiple years. I have seen in the past Week-on-Week comparisons but one of the challenges is what happens when it overlaps years. Especially at the start of a year like it is now Feb 2021, the users want to compare week-on-week for the past 3 months. My challenge…