Press "Enter" to skip to content

Category: Power BI

Workspace Identity Authentication in Power BI

Published 2025-12-11 by Kevin Feasel

Teo Lachev looks at a new way of authenticating:

What credentials do you use to refresh your Power BI semantic models from Azure SQL SKUs, such as Azure SQL Database. Probably your credentials or a designated Entra account? Both are not ideal for a variety of reasons, including requiring a password. More advanced users might be using service principals, which are more secure but require secret renewal after a maximum of 24 months, which is a hustle.

Read on to learn about a new alternative in workspace identities.

Leave a Comment

Accessing Excel Files from OneDrive via Power BI

Published 2025-12-09 by Kevin Feasel

Kristyna Ferris is happy:

I can’t believe it’s finally here! A way to have Excel live in OneDrive and access it from Power BI nearly live! We can officially short cut files to our OneLake from both SharePoint and OneDrive! I am super excited about this feature, and I hope you are too. This feature plus User Data Functions allows us to not only have data from Excel in our reports but keep it as fresh as needed. Imagine having budget allocations that you want to adjust right before or during a meeting. Now you can! You can edit a file in Excel and hit one button to see the new numbers in your report. In the past, we relied on 3rd party services or Power Apps licensing to accomplish this sort of experience. Now we can just use Excel, an old data friend.

Kristyna does note that this is in preview, so take it with that caveat in mind and read on to see how it all works.

Leave a Comment

Building a Lollypop Visual in Power BI

Published 2025-12-08 by Kevin Feasel

Valerie Junk creates a visual:

In this tutorial I want to show a fun little trick in Power BI. We are going to create a lollipop visual. And yes, I am still searching for a strong business case, but it is a very nice visual and the steps you take to build it can help in many other situations.

If you want to show trends without focusing too much on exact numbers, this visual works surprisingly well. And the best part is that you can build it with the standard line chart.

Read on to see how.

Leave a Comment

Calendar-Based Time Intelligence and DirectQuery Performance

Published 2025-12-02 by Kevin Feasel

Chris Webb hits the Turbo button on his PC:

Calendar-based time intelligence (see here for the announcement and here for Marco and Alberto’s more in-depth article) is at least the second-most exciting thing to happen in DAX in the last few months: it makes many types of time intelligence calculation much easier to implement. But as far as I know only Reid Havens, in this video, has mentioned the performance impact of using this new feature and that was for Import mode. So I wondered: do these benefits also apply to DirectQuery mode? The answer is on balance yes but it’s not clear-cut.

Click through to see what Chris found.

Leave a Comment

Common Star Schema Mistakes

Published 2025-12-01 by Kevin Feasel

Ben Richardson gets back to basics:

Sometimes the culprit isn’t actually your DAX, it’s your data model.

Star schema mistakes are incredibly common in Power BI, and really hard to track down.

When your data model isn’t a clean star schema, you end up with broken filters, confusing relationships and slow visuals.

It’s important to get it right from the start! So we broke down the top 10 most common mistakes people make, how to identify them and how to fix them!

This is where reviewing (or reading) Ralph Kimball’s Data Warehouse Toolkit can save you a lot of time and stress. The Microsoft data analytics world is predicated so heavily on Kimball-style dimensional modeling that the choices tend to be building a proper star schema up-front or spend processing and developer time trying to fix it in post-production using DAX or trickery.

Leave a Comment

Power BI Build Permissions

Published 2025-11-24 by Kevin Feasel

Chris Webb explains what the Build permission actually does:

If there is sensitive data in your Power BI semantic model that you don’t want some users to see then you need to use row-level security or object-level security to control access to that data. You’re an experienced Power BI developer – you know that, right? But what about Build permissions? If an end-user only has access to a report you’ve built and doesn’t have Build permissions on the underlying semantic model, and if there’s no other security on the semantic model, can they access data in the semantic model that isn’t visible in the report? The answer is potentially yes: you can’t rely on Build permissions for security.

I’ve found that the best method of security is never deploying products to begin with. Also, never using a computer.

Comments closed

Accessing a Former Employee’s Power BI Workspace

Published 2025-11-21 by Kevin Feasel

Gilbert Quevauvilliers says it’s MY workspace now:

One of the common challenges I’ve seen in organizations is when a team member leaves and their Power BI reports are stored in their personal My Workspace. These reports often contain valuable datasets and dashboards that are still in use or need to be maintained. So, how do you access and recover these reports?

In this blog post, I’ll walk you through the steps to access a former employee’s My Workspace, assign it to a supported capacity, and download the reports using Fabric Studio.

Read on for the instructions, and be sure to do the “Look at me. I am the captain now” meme when it works.

Comments closed

Power BI Projects and PBIR Format Admin Settings

Published 2025-11-21 by Kevin Feasel

Koen Verbeeck notes a new default:

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it in the preview features of Power BI Desktop (also enable PBIP and TMDL to make git integration of the model itself much easier).

Read on to see the administrative setting associated with this, as well as reasons why you should keep it on.

Comments closed

Binding Power BI Thin Reports to a Local Model

Published 2025-11-20 by Kevin Feasel

Ed Hansberry cuts the fat:

You may have an issue though where it isn’t in the service and you need to connect your report to a local model on your desktop. This can be useful if you need to do some testing and don’t want to connect it to a model in the service, or you temporarily don’t have access to the service. Let’s see how this works.

What you need:

  • Your thin PBIX report file. You can download this from the service if necessary.
  • Your local model in Power BI Desktop. It must be up and running.
  • Windows File Explorer

Read on for the process and a demonstration.

Comments closed

Multiple Record Writeback for Translytical Task Flows

Published 2025-11-18 by Kevin Feasel

Jon Vöge wants to write multiple records at a time:

Having presented a few sessions on Translytical Task Flows at conferences in the past moths, there is one major recurring question:

How do you write-back multiple records at once?

If you ask me, the questions of bulk write-back/writing back multiple records at once can be understood as two separate user stories, which sound similar, but are technically different:

Click through for those two questions as well as the answer to the first.

Comments closed