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
When I started as a BI consultant, the only way to create page navigation in Power BI was by using bookmarks and my other main use for bookmarks was creating a “Clear filters” button, to reset all my slicers in a report. In this article, I’ll show some extra usage for buttons and bookmarks. Relative … Continue reading Power BI buttons & bookmarks
I once had a customer who had a large collection of data from different subsidiaries. These companies were only allowed to see their own, anonymized data, but the Security Officer of the main company also needed to see the Personal Information (PI) of all employees. Eventually we “solved” this by creating two reports, which also … Continue reading Power BI datasets and Object Level Security (OLS)
A few days ago, someone asked me to think of a solution to show the responses of a Microsoft Form in Power BI. During this project, I used Forms, Power Automate, Excel, OneDrive, and of course Power BI. I found some interesting obstacles that I want to show you, but first, I start creating a … Continue reading Showing Microsoft Forms results in Power BI
Improve the quality of your solution from a DevOps perspective Developing ETL or ELT solutions in smaller or larger teams has never been easier with the help of DevOps. It enables us to be certain that the solution still works after multiple team members made changes in different parts of the solution. For example changes … Continue reading Automated Testing of Azure Data Factory Pipelines
A few weeks ago one of my colleagues showed me a PowerShell script to export all Power BI reports from a Power BI Workspace. This could come in handy for back-up purposes (version control is still hard to accomplish) or if you don’t have access to the PBIX files via the normal way and you … Continue reading Exporting all your Power BI reports at once
Something went wrong. Please refresh the page and/or try again.
Follow my stories
Receive new stories directly in your inbox!