Debbie’s Microsoft Power BI, SQL and Azure Blog

Photo working process. Account manager working new global project in office. Using tablet. Graphics icons, worldwide stock exchanges interface.
  • Power BI Updates August 2020 Organisational visuals in Power BI Admin

    August 28, 2020 by

    Power BI report developers can either use the default Power BI visuals, or go to AppSource to pick up visuals. Some of these visuals are available within Power BI certified, which means that these visuals have been through rigorous tests and have passed all the requirements. But there are many other visuals you can use.… Read more

  • Calculation groups with Tabular Editor for Power BI

    August 14, 2020 by

    Calculation groups look like a game changer, but are they? These have been available for Analysis Services tabular models for a while. Now Tabular editor Lets you build calculation groups for Power BI. Taking one of our current pbix files as an example. There are metrics for number of events, Financial metrics, timing metrics. Each… Read more

  • Power BI July 2020 Mini Blog – Launch External Tools

    July 30, 2020 by

    This is part of the Semantic modelling for Power BI Programme and its a big one. Very exciting The first thing you should see is External Tools on your ribbon (Making sure you are on the Jusy 2020 release of Desktop) In the first instance, this doesn’t appear to be avilable. Why is this missing?… Read more

  • Power BI July 2020 Mini Blog – Gradient Legends

    July 29, 2020 by

    Its always nice to work through the updates by relating them to something you are working on. Lets have a look at the Gradient Legends lets start with a simple events chart for 2020 the Measure is Number of Events = DISTINCTCOUNT(‘Event Metrics'[Event Id]) So Now lets colour the columns based on number of Events… Read more

  • Power BI why marking a date table is a good thing

    July 29, 2020 by

    We are looking at a Star Schema with a Date table connected to the Fact table by Order date Key for these examples, the active relationship is the only one that matters Lets have a look at all the issues arising from using the Date table without marking at a Date table Date Slicer seems… Read more

  • Power BI Row Level Security 2 – Dynamic Security

    June 30, 2020 by

    We have already looked at a very simple Static Row level solution example using two tables. Now We move to dynamic security Here you create 1 rule only and the users are added to a table. Each logged in user will see their own data. Dynamic Row Level security therefore uses a Users log in… Read more

  • Power BI Pipeline Issues and Access requirements

    June 25, 2020 by

    In a previous blog we looked at setting up a Pipeline However, we have found an issue, when you Deploy to Test or Production. the issue resulted in getting a better understanding of the permissions you need in order to create and control the process The Deployment hangs and doesn’t continue on to creating a… Read more

  • Power BI Deployment Pipelines

    June 25, 2020 by

    In May 2020 a new pipeline appeared. Deployment Pipelines Having worked with Devops, It looks like it is identical to the Pipeline that allows you run builds, perform tests and release code to the various production environments. Power BI deployment Pipelines are a new way for BI teams to manage the content lifecycle. It is… Read more

  • Power BI Row Level Security 1 – Static Security

    June 23, 2020 by

    Enabling different roles and giving users access to different levels of data is called row based security. For example; Managers of different departments should only see data for their own department. Higher level users should be able to see everything To show how Row level security works, we are going to use the Azure Database… Read more

  • Power BI Lineage and Impact Analysis

    June 23, 2020 by

    Another new feature from the May 2020 Microsoft Business Applications Summit This became available in April 2020 and its a fantastic feature. Lets have a look at it There is a lot going on in the Adventureworks Portal. Lets go to View to go into the Lineage View The Lineage View gives us a lot… Read more

  • Power BI dataflows – Takeover

    June 17, 2020 by

    Dataflows allow you to separate your data transformations from your data sets. we can now centralise the dataflow and connect to the flow in power BI Desktop instead of having to connect to the data. to create a dataflow, instead of getting data within the Power BI desktop pbix file, you create a dataflow in… Read more

  • Quick Incremental Refresh check List

    May 29, 2020 by

    Incremental Refresh came available for Power BI Pro a few months ago but when tested there was am issue. Error Resource Name and Location Name Need to Match. This should have been fixed in April so here is a quick check list of how you approach incremental Refresh Define your Incremental Refresh Policy What is… Read more

  • Azure Built in Tagging Policy Resource Group to Inherit Subscription tags

    May 5, 2020 by

    Ensure your Azure Resource groups are tagged with the Tag from Subscription In this example we have the following requirements The costCentre tag has been manually added to the Subscription The Resource Group inherits from the container they are in, but can be manually overridden Costcentre Tag Configuration Modify Resource Group to add the Costcentre… Read more

  • Azure Built in Tagging Policy. Deny the Creation of a Resource group

    May 5, 2020 by

    Deny the creation of a resource group without applicationName Tag Every resource group should have an application name because Resource Groups should be Application Related. However you cant get the applicationName from the Above Subscription. As a Example, the Resource Group is for HR Performance. applicationName Tag Configuration Deny the resource group if its missing… Read more

  • Azure Use Policies for Tagging Introduction

    May 5, 2020 by

    When you get started with Azure, you want to ensure that your resource groups and resources are tagged. this is great for Management of your Azure Subscriptions/ You can categorise all your resources with tags. You can also view Billing by Tags. When you add a tag into the Portal (Or programatically) you can add… Read more

  • Azure Tagging with Powershell Example

    April 27, 2020 by

    Azure uses Tagging for easier management. Tagging is done with Key value pairs. You can create the manually in the Azure Portal but you can also do it programatically via Powershell (For Example) For this example Log onto the Azure Portal, Open Cloud Shell (This is the new Azure Portal, Not classic) And set it… Read more

  • Introduction to Azure Tagging

    April 21, 2020 by

    Tagging is a feature that has been introduced into the Azure Resource Manager model (ARM). They can be used to Logically group and track resources. The old (Classic) version of Azure was Azure Service Manager. Azure tagging can be done using Azure Portal, Azure Powershell, CLI (Command Line User Interface) or ARM (Azure Resource Manager)… Read more

  • Azure keeping your costs under control with Spending Limits and Budgets

    April 6, 2020 by

    We can now start adding Subscriptions for all our different Business domains and environments. Azure allows you to quickly get started adding Resource groups and Resources to your subscriptions. Using Management groups above subscriptions allows for even more control. You can manage access, policy, and compliance across multiple subscriptions. This is all great but what about… Read more

  • Setting up a Board in Azure DevOps (AGILE)

    March 20, 2020 by

    Its time to start tracking Projects with Azure DevOps boards. With Boards, teams can manage software Projects. They can track user stories, backlog items, tasks, features etc. You can choose the environment you want to work with like AGILE or SCRUM. For this example, there is only one developer (me) and I’m am tracking my… Read more

  • Power BI March 2020 New Drill through Functionality

    March 17, 2020 by

    Currently we have lots of visuals on the report pages and the only way to know that they drill through to other reports is to hover over them In the March 2020 release there is new functionality in the form of buttons Add a blank button This button is now set to drill through preview… Read more

  • Power BI 2020 Updates. Hierarchical Slicer

    March 12, 2020 by

    We currently have a report with a hidden slicer panel, and one of the slicers is for Date. We want the user to choose the month of the report Click on the visual and you can see that its the Hierarchical slicer from the Market place However, Power BI February 2020 updates includes this feature… Read more

  • DevOps Organisation Settings

    March 10, 2020 by

    Lets have a look in a little more detail at the Settings for the DevOps Organisation Level and at what the Organisation is. When setting up DevOps, it created at Organisation level of [My Name] , and another Organisation was then created manually for the company Organisations can be treated as accounts and each organisations… Read more

  • Making Sense of Pricing for Azure DevOps to get started

    March 6, 2020 by

    You decide that Azure DevOps is the way to go because you want to make use of all the features. Specifically Azure pipelines to build and release code Boards to do all your planning Repos so you can use, for example GiT as your code repository Artifacts to share packages across projects Test Plans to… Read more

  • Introduction to Azure DevOps

    March 6, 2020 by

    What is Azure? Taking the first part of Azure DevOps, Azure is Microsoft’s Cloud computing platform. It hosts hundreds of Services in over 58 regions (e.g. North Europe,West US, UK South) and available in over 140 countries. As you can see, lots of Azure services have already been consumed throughout these blogs. Azure SQL Databases,… Read more

  • How does Power BI cope with Source Data Changes?

    February 20, 2020 by

    You have a data source that you are connected to with a some nice reports and DAX However, at some point your data source changes. In this example I have moved from this To The question is, what happens to our report when we load in this updated data set? Straight away when we attempt… Read more

  • Azure Subscriptions

    February 17, 2020 by

    The World of Azure Subscriptions and setting up a good Azure architecture can seem quite daunting (because it is).  Here is a guide to Azure Subscriptions and how they work. Free Subscription When you first go into Azure you can start for free. This is probably the most used subscription starting point. There are services… Read more

  • The Dos and Donts of Power BI relationships and Modelling

    February 7, 2020 by

    Bad Modelling 1: Single flat file table e.g. Salesextract When people first start out using Power BI as their Analytics platform, there is a tendency to say, lets import all the data in one big flat file, like an Excel worksheet. This way of working is just not well organised and doesn’t give you a… Read more

  • Moving Power BI to different Environments (Dev Test Production etc)

    February 5, 2020 by

    Currently we are in Development and I only have a Development database to connect too. However, very soon there will be multiple environments to connect too Development Q&A Production Test Currently the development area is simply hardcoded If you need to change to a different environment to test the Power BI Reports against this environment,… Read more

  • Introduction to DAX

    February 4, 2020 by

    I have gone through a fair few training courses on DAX now because its an important part of Microsoft Analytics. I thought It would be nice to include all my notes from one of the first DAX courses I attempted. You don’t have to be an expert on DAX to get started with Power BI.… Read more

  • DAX – ISLOGICAL

    January 31, 2020 by

    This function checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE. I just looked a question that asks, what does this DAX expression do? is logical measure = IF(ISLOGICAL(“true”),”Is boolean or Logical”,”Is different type”) I could just have a guess based on If “true” is logical then “Is… Read more

  • Buying and Pausing a Power BI A SKU

    January 23, 2020 by

    I want to set up Power BI Dedicated Capacity specifically for development and testing Premium features. the Power BI Premium SKU’s should only be used in production. We want something that we can pause when not in use and help us to research all the Premium capabilities. Thankfully we can go for the A SKU… Read more

  • What if Parameters in Power BI

    January 22, 2020 by

    I wanted to have a look at What if Parameters in Power BI. This had passed me by so using Adventureworks I wanted to get a handle on it. I have a simple problem. I have a sales goal Id like to achieve over the months and Id like to see how adding percentages onto… Read more

View all posts

Follow My Blog

Get new content delivered directly to your inbox.