In one of my first blogs, I describe a method of how to add external people to your Power BI workspace. You can read that one here. Now there is a problem with that. Before, you got an e-mail with a link to that specific workspace and could access the content. When you click on the … Continue reading Adding external users to your Power BI workspace — Update
Intro Since I started working in BI, I saw a lot of colleagues using dark mode options, whenever they could. And when Microsoft revamped the desktop application to a light one, there were so many people asking for an option to change it back to dark. As far as I know, this hasn’t happened so … Continue reading Creating a dark and light theme for your Power BI report
With Data in space, Microsoft gives you the option to get an idea of what the future may look like. In an augmented reality experience, you can pin Power BI reports using Azure Spatial Anchors. In this blog, I’ll show you how this works and what you need to do to set this up. Azure … Continue reading Using the new Power BI — Data in space preview
For a while, I wanted to create this demo, for which I’ll be using Power Apps to insert data into an Azure SQL database and show the results in our report. In this example, I’ll insert and update some records, refresh the page, and refresh the dataset using Power Automate. There will be two examples: … Continue reading Use Power Apps to write into Azure SQL Database
Intro When I was working for a customer two years ago, they requested to use the data hierarchy (Year, Month, Day) in a graph in Power BI. No problem, I included the hierarchy on the X-axis of multiple graphs and showed them how to use the drill-down option. But then they said: I don’t want … Continue reading Using the new Power BI Field Parameter to give your end-users more flexibility
One of the clients I work for, got a request which includes geofencing. A geofence is a virtual perimeter for a real-world geographic area. It needs at least three different coordinates to create a shape. In this article, I will describe what my colleague and I did to complete this request and what is needed for that. … Continue reading Using a geofence in Power BI
The problem Sometimes you want to have information from “the previous row” in your table. The problem is, your measures don’t have row context, so it doesn’t know on which row it is. Creating a column will solve this problem easily, but generally, it’s best practice to use measures. In this blog, I’ll explain what … Continue reading Getting data from the previous row in your table visual in Power BI
In case you need to access an Azure SQL Database from your DevOps deployment pipeline to execute some custom script on a database. If you need to use something other than a username and password authentication and want to leverage Azure Active Directory, using an Access Token might be your solution. In this post, I … Continue reading Azure SQL Access Token Authentication with Python and Azure PowerShell from Azure DevOps Pipelines
Some tips on how to effectively secure your production environment In this post I just want to talk about approaches on setting ‘Approvals and Checks’ in Azure DevOps. Recently I came to the conclusion that we have been using this in a suboptimal way. But first let me give you some basic context what we’re … Continue reading Azure YAML Pipelines Secure your Environments
Power BI has always been about making your data visible. By creating pie charts, line graphs, tables, and all other kinds of visuals, you can show organizations their performance in finance, sales, you name it. With KPI Cards you can show if they’re on track with their target, and with alerts in dashboards, you can … Continue reading Power BI Goals, a new way in tracking your KPI’s
Something went wrong. Please refresh the page and/or try again.
Follow my stories
Receive new stories directly in your inbox!