r/PowerBI

Learning Power Platform? Check This Out 👀
▲ 9 r/PowerBI+3 crossposts

Learning Power Platform? Check This Out 👀

Hey everyone 👋

I recently started a YouTube channel focused on real-world Power Platform content.

I’m currently doing a “100 Days, 100 Problems” series where I solve actual problems from r/PowerApps and turn them into working solutions.

YouTube: connectedbytech

If you’re new to Power Apps, start with Understanding Power Apps Studio

Recently I built a Seat Booking App in Power Apps

Would love feedback and suggestions from the community 🙌

u/apurva96 — 3 hours ago

Hooked up the Power BI modeling MCP to Codex and I finally stopped thinking about tokens altogether.

Everyone's been complaining about Claude eating through tokens mid-session and I get it, it was killing my flow too. Haven't seen anyone mention connecting it to Codex instead - which is currently free as far as I know. No more context running out, no more starting over. If you haven't tried this yet, might be worth it. Anyone else made this switch?

reddit.com
u/Worldly-Effective648 — 3 hours ago
▲ 84 r/PowerBI+1 crossposts

PBIR CLI v0.9.20 is out

If you've been following PBIR CLI, developed by me & Kurt Buhler, you will be happy to hear that the new v0.9.20 release with bunch of bug-fixes is out.

PBIR CLI focuses on visual layer and allows to create Power BI reports/visuals agentically. For semantic models agentic development refer to my other tool: semanticops.dev.

Download PBIR CLI here: https://github.com/maxanatsko/pbir.tools/releases

Changelog

New

  • Code signing - binaries now come code signed both on Windows and macOS.
  • Page conformance - pbir pages conform enforces visual formatting properties (title, background, border) against theme defaults across a page or report, with --dry-run preview, JSON output, and idempotent apply mode
  • Field where-used - pbir fields where-used finds every visual and filter that references a given field, with exact and substring matching

Bug Fixes

  • Card visuals now apply font color conditional formatting correctly using the Power BI default dataViewWildcard selector, fixing pbir visuals cf on cardVisual value properties
  • pbir fields and pbir tree now traverse report pages by directory path rather than display name, so pages with em dashes, parentheses, or other path-like characters in their names resolve correctly
  • Visual group parent links broken by pbir connect downloads are now repaired automatically during download, and group membership changes are tracked through the object model change history
  • Visual group operations (list, ungroup, group workflow) are now more reliable: page and path validation is enforced before mutations, cleanup is persisted after ungroup, and edge cases in multi-step group workflows are handled
  • pbir visuals bind now fails closed when the semantic model cannot be loaded - explicit --no-validate is required to proceed, and the model load error is surfaced in the output
  • Validation JSON output now includes model_load_error detail alongside the existing model_loaded flag
  • Validation now reports orphan parent groups and stale visual interaction entries as diagnostics
  • Animated startup splash is replaced with a static splash on Windows and non-interactive consoles, fixing rendering artifacts on Windows terminals
  • Microsoft schema and bundled runtime artifacts were refreshed to May
u/maxanatsko — 10 hours ago

Only just realised this!

I must have been working with PowerBI for at least 7-8 years now and only just realised why I make the same mistake every single time.

https://preview.redd.it/fm8nmf4e4p2h1.png?width=202&format=png&auto=webp&s=b30c506e06e1737a39a2b977041f32945c0c4a7f

I click height, (you know the uppy downy size) type in my visuals height, tab, do the width, tab (its a triple tab) and type the uppy downy position) tab and type the righty left position, then go feck thats not right and click in and switch it.

WHY are the uppy downys and the righty leftys not in the same order! 🤣 My brain is not programmed this way 🤣

reddit.com
u/CyclingDad88 — 5 hours ago
▲ 67 r/PowerBI

Something different, thoughts?

Tried building a Kanban-style workflow dashboard in PowerBI instead of the usual table heavy approach.

Honestly surprised by how intuitive it feels for tracking tasks and status.

Anyone else using PowerBI beyond pure reporting or dashboarding lately? And curious what the PBI crowd thinks.. Feedback is welcome!

u/officialpiqo — 1 day ago

How to merge 20 reports/semantic models?

What’s the best way to take bits and pieces of information for 20+ reports and brining that all together and joining them by date and location? These reports live with different departments at the company. What’s the out of the box thinking approach I should consider or should I just direct query all these reports and semantic models into one big semantic model?

reddit.com
u/No_Smell_6712 — 16 hours ago

Modeling Data From A LIMS

I‘m making a dashboard for my lab’s SQL Server based LIMS. We have samples and, for example’s sake, five different tests we can run on them. Depending on the sample type, some or all of the tests may be performed, which leaves a lot of null data in the table.

I am wondering if I should out each test into its own table with a Sample Id and Result and remove the nulls in Power Query. This also seems advantageous since I have a different target for each test and sample type, and a DAX calculation that will use the target to determine pass/fail.

Intuitively this seems faster but more complicated to work with. Is it worth breaking each test out into its own table and having my DAX pass/fail formulas just check for nulls?

reddit.com
u/DannyBongaducci — 17 hours ago
▲ 28 r/PowerBI+1 crossposts

What’s everyone’s take on the May 2026 Power BI update so far?

After digging through the May Power BI update, this one feels more focused on usability and report experience improvements than major platform shifts, but there are a few features I think could actually impact day-to-day report development quite a bit.

A few things that stood out to me:

  • Visual calculations + custom totals reaching GA feels important. Curious whether people are actually starting to use visual calculations in production yet, or if most teams are still sticking with traditional DAX patterns.
  • Input slicer numeric support seems small at first, but honestly opens up a lot more practical use cases for parameter-style filtering and user-driven analysis.
  • The new fixed/default column widths for matrix and table visuals might be one of the most underrated additions in a while. I know a lot of people have struggled with layout consistency in dashboards.
  • Matrix Explore improvements also seem interesting, especially for self-service analytics scenarios where users want to drill into data without needing entirely separate report pages.
  • The Copilot summarize shortcut feels like another signal Microsoft is continuing to push AI directly into everyday reporting workflows rather than treating it as a separate experience.
  • The Azure Maps formatting pane updates are nice too, though I’m curious how many people here are heavily using Azure Maps vs other mapping visuals.

Overall this update feels more polished/productivity-oriented compared to some of the larger Fabric-focused releases recently.

Curious what others think:

  • Which feature here is actually most useful in real-world reporting?
  • Anyone actively using visual calculations in enterprise reports yet?
  • Do you think Copilot integrations are becoming genuinely useful, or still mostly early-stage?
youtu.be
u/PowerBIBro — 1 day ago

Pl-300 round 2 and got 687😞☹️

I’m so close to loosing it cause Wdym I needed only 13 points💔💔💔💔💔
Please let me know what resources I need to use/buy
I’m not retaking this exam after the 3rd attempt 😭😭
I’ve already used measureup so that won’t work for me here!
Thanks

reddit.com
u/Ok_Impression_9799 — 23 hours ago

Stuck with a mapping issue

Hi to all the experienced data analysts,

My question to you is, I am working in my current org from 6 months, from the moment I have joined, something or the other goes wrong with me, in the first month I joined there was an escalation, as I was late with a dashboard. Then something or the other kept coming up, just when I thought I was above it all a critical dashboard hadn’t refreshed from 2 days, all the leaders review it continuously, and I took half day for it to be up (it takes 2/3 hours to refresh it). And now I am again running late with a dashboard. Am I not a fit to be a data analyst?

I need your impartial opinion.

reddit.com
u/Soft-Tear6050 — 1 day ago

Power BI Template with Persistent Filter off

Anyone know how to create a Power BI Template that has Persistent Filter off the goal is to have a template to save time with turning off persistent filter every report built and a template with a few standard things we have across all our reports

reddit.com
u/Pristine_Practice134 — 21 hours ago

Can someone help me with advice on how to filter data inside a matrix visual in Power BI?

I have Current, Previous, and Diff periods created using Tabular calculations. To display the measure names separately, I moved them into a text field above the matrix. However, I can’t get the filtering to work properly, and because of that the visual becomes basically useless in Power BI.

https://preview.redd.it/n5lbutzh8j2h1.png?width=1280&format=png&auto=webp&s=da5254be41653daed30700b1a7c03a710752dbd4

reddit.com
u/iden_kai_ — 1 day ago

Use two date filters on different columns in table

https://preview.redd.it/geg1m5gp0i2h1.png?width=766&format=png&auto=webp&s=4b0b965ef7130c93db07d0a443988d956cfacb4c

I'm tasked in creating a table where the users can change the year and quarter in one filter, and the first column will fetch the cost for that period. The second quarter + year filter will work the same but fetch the cost for that specific period.
Lastly we want to evaluate the difference between the columns and present the change in %

I have one table with nr, cost and date and a separate date table where year and quarter are mashed together.
I'm at a loss at how to solve this without duplicating the fact table.

https://preview.redd.it/dmzjt2a1ch2h1.png?width=789&format=png&auto=webp&s=d0be8bd17b941aba2b78d000a83e0094ef874173

reddit.com
u/talidass — 1 day ago

Power BI Intern asking for help

Hello everyone! I’m a new Power BI intern and I’m encountering a problem.

I have 2 tables, one big (fact) table which contains invoices data which we paid to our vendors, and there is a “country code” column inside it which I’m trying to connect to “legal entity code” column from the other (dimension) table.

The relationship works, but the data from the dimension table returns as blank. I already changed the type of both data to “text”, and tried clearing/formatting the code (i forgot the function name cuz i’m at home now) but nothing seemed to work. I also tried changing the relationship to be both ways, many to many, etc, all things but no combination seemed to work.

What could the solution be, and what am I doing wrong?

reddit.com
u/taeyong18 — 1 day ago

Matrix column cut off in pdf export

Our company relies heavily on pdf exports of PBI reports. Just realized a column is cut off in a matrix after exporting. Is there any way to prevent this from happening?

I am aware of paginated reports.. we do not have the time to recreate things in paginated report builder right now.

reddit.com
u/OwnFun4911 — 1 day ago
▲ 54 r/PowerBI

Power BI May 2026 Feature Summary

Monthly Update

Microsoft Power BI Updates Blog: Power BI May 2026 Feature Summary

Some notable releases this month:

Preview burn down!!!

Notable Updates:

Reported, Fixed, or Documented

---

Stay up to date

---

Disclaimers:

  • We acknowledge that some posts or topics may not be listed, please include any missing items in the comments below so they can be reviewed and included in subsequent updates.
  • This community is not a replacement for official Microsoft support. However, we may be able to provide troubleshooting assistance or advice on next steps where possible.
  • Because this topic lists features that may not have released yet, delivery timelines may change, and projected functionality may not be released (see Microsoft policy).
community.fabric.microsoft.com
u/itsnotaboutthecell — 2 days ago

Summary Report from Other Reports

I'm asked to create a summary report from the reports published by various teams, some sort of report of the reports because some C-Level doesn't want to see all the reports but certain parts of it.

Actually, I understand the request but I find it a bit tricky to implement in Power BI.

I'm thinking of the following three solutions:

Workspace Apps (or Org Apps)

Main problem with this is the reports are in different workspaces. I have to create a copy of each report in a specific workspace and I don't know how to keep the original and the copy in sync. (maybe deployment pipelines?)

Dashboards

I can pin visuals to a dashboard but I'm not a big fan of this object. It looks outdated and isn't very flexible/customizable.

Having reports in different workspaces is creating the same issue as in Apps.

Connecting to the Semantic Model of each report

This is the option I'm looking at. I will create a new semantic model that reads the measure table from different reports and I will revisualize them. For 3 reports it works well but I'm not sure if I will hit performance issues with more semantic models (let's say 10+).

I'd love to hear from you if you came across a similar situation.

Note: I have access to Premium Capacity (Fabric features are blocked)

reddit.com
u/HasiRuebli — 1 day ago

Can you drill through with context?

I would like to create a drill through for a table that has multiple values.

The table would have client, invoice number, and aging buckets like 0 to 30 days, 31 to 60 days, etc.

When I drill through on a 31 to 60 days, I want my drill through page to only show invoices that have values other than 0 for 31 to 60 days. But right now it shows all invoice aging buckets. But I also want it to be able to filter for the other buckets as well so if you drill through on 0 to 30 days you only get non zero for those.

I would very much like to avoid creating multiple drill through pages with hard filters if possible.

reddit.com
u/pabeave — 2 days ago

Beginner question: Folders

I learned about using a folder as my data source. I have 2 files in it to pull data from. Every time I go to combine the data, I get an error from one of the files.

I've spent hours working on cleaning up the data. I can't find any differences between the two files.

I want to be able to do this, I just have no idea what I'm doing wrong

reddit.com
u/socialerrors — 2 days ago