The sort by column feature of Power BI hides some potentially unwanted complexities. This blog post shows how you can avoid having to sort a column by another column while maintaining a custom sort order. The problem Here’s a typical example: you sort month names by month numbers. Let’s say you want to remove filters… READ MORE
With Power BI you can set up a scheduled refresh of any dataset which have an accessible data source. But you must be aware of, how many refreshes are at the same time. With every particular capacity you have only limited parallel refreshing resources. So, you can only refresh one dataset at the same time… READ MORE
In this blog series I will set apart all the steps needed to get this demo up and running on your own. I will use the text in this post, as well as screen shots and video’s explaining it step by step. So if you’re already (somewhat) familiar with Forms, Power Automate and/or Power BI… READ MORE
I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last two functions I create for Power BI Report Server for a little while. I’ll be working on SSAS cmdlets for the next week or two. RECAP… READ MORE
Occasionally in Power BI, you may want to display day or month names as single letters to save space. This may result in duplicates because neither day nor month names are unique when you shorten them to one letter. In this blog post, I’m showing two solutions to the problem: one in DAX and one… READ MORE
In this article, we will be talking about the new Power BI experience in Microsoft Teams. During Ignite 2020, Microsoft announced that users can now use Power BI Service from teams without leaving the context of Teams. This feature is very useful for modern workspace users where we can use Microsoft Team as a centralized… READ MORE
Hidden gems! Slicer Pain Relief in Power BI! Power BI is full of them…Sometimes, you find them after thorough research, and sometimes they just appear out of nowhere. This post won’t be long – it’s just an homage to Power BI and one of its handy features that will make your life easier in specific… READ MORE
This is the title of a live demo session that demonstrates the Microsoft Power Platform products working together to create an interactive data application. I recently had the honor of presenting this at the Dublin Power BI User Group (@DublinPUG) during my visit to the Power PlatformWorld Tour in Dublin. The slides of my regular session… READ MORE
After Installing the PowerShell Power BI Management cmdlets a few months back, I finally managed to get a dataset refresh working, initiated from PowerShell with a Service Principal. Yeej 🙂 But as you can imagine, it didn’t go without a fight (or 2, or maybe more), so I thought it would probably be good to share my… READ MORE
This article will guide you through the implementation of CI/CD pipelines using Azure DevOps. This will enable you to deploy your local report to your Power BI service automatically. To show you how it works, I will use an extension called Power BI Actions, available for free on the Visual Studio marketplace. Azure Portal Create a… READ MORE
