Stories

Using a geofence in Power BI

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

Getting data from the previous row in your table visual 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

Azure SQL Access Token Authentication with Python and Azure PowerShell from Azure DevOps Pipelines

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

Power BI buttons & bookmarks

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

Power BI datasets and Object Level Security (OLS)

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)

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow my stories

Receive new stories directly in your inbox!

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close