Analyzing Teams data over a full year
How can you see all of your MS Teams statistics over a full year and what information can you get out of that? Let’s find out!
Using Paginated Reports in Power BI
Since paginated reports will become availible for Pro users, it’s time to see how you can create your first one!
How to CI/CD Synapse Serverless SQL
A custom solution with Python and Pandas for an incremental deployment. In this post, I will explain why I created a custom solution and how to use it. All code can be found in my GitHub Repository, linked at the end of the post.
Adding external users to your Power BI workspace — Update
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…
Creating a dark and light theme for your Power BI report
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…
Using the new Power BI — Data in space preview
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…
Use Power Apps to write into Azure SQL Database
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:…
Using the new Power BI Field Parameter to give your end-users more flexibility
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…
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.…
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…
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow my stories
Receive new stories directly in your inbox!