r/PowerBI • • 5d ago

Question Design a "Data Kicks" shoe. Win. We'll print it for you!

Post image
0 Upvotes

All I'm gonna say is this sub knows a thing or two about design.

Details are here --> https://aka.ms/datakicks


r/PowerBI • • 20d ago

Discussion November 2026 | Job Opportunities

10 Upvotes

Welcome to the monthly job thread!

Posting a job or opportunity? Include:

  • Role title and description
  • Location or remote/hybrid status
  • Company or client context
  • Direct application link

Looking for work? Share your skills, experience level, and what you're looking for.

Rules:

  • One top-level comment per opportunity
  • No "DM me" or link-free posts — include a direct, verifiable link
  • Scam or misleading comments will be removed and may result in a ban

r/PowerBI • • 18h ago

Community Share Free Power BI theme (light + dark) and theme builder

13 Upvotes

Sightline is a free Power BI theme in light and dark. It styles 45 visual types plus the filter pane and the page, and it comes with presets (Minimal, Labelled, Dense, Comparison, Presentation) that mean the same thing on every chart type.

light-theme preview
button designs
colours, fonts and sizes live in variables.json; the visual definitions reference them as {{…}} placeholders.

To make it easy to change, I built it from variables: about a hundred colours, fonts and sizes are defined once in one file, and the visuals inherit them. Shared things like axes, legends and borders sit in the wildcards, and each visual only sets what’s different. The dark version just overrides a few variables, so it stays in sync with the light one. The build also checks contrast, so if you swap in your own colours you find out straight away which ones aren’t readable.

If you just want to try it, download from releases and import it under View > Themes. There's also a preview report in the repo with every visual on dummy data.

Docs and screenshots: https://itschrishaas.github.io/sightline-powerbi-theme/
Repo: https://github.com/itschrishaas/sightline-powerbi-theme


r/PowerBI • • 20h ago

Question Confused on Extract Text Between Delimiter Advanced Function Power Query

5 Upvotes

So in this video i'll explain what im confused about. I know to get the value that i wanted in this video i can use the basic function instead of advanced but im wondering why it doesn't work by my logic there. Thanks.


r/PowerBI • • 17h ago

Question How to publish Power BI reports and semantic models as part of CI/CD pipeline on GCC?

3 Upvotes

Curious how people handle automatically publishing without access to Fabric (e.g., fabric-cicd). I find all the clicking annoying. I just want to accept a merge/pull request related to a pbip fill and have the report show up where it's supposed to. Seems like that's kinda what MS is now building towards, but it's still super clunky.


r/PowerBI • • 1d ago

Discussion Claude + PBIP - is it safe?

154 Upvotes
More and more of us open PBIP projects in VS Code with Claude Code or another AI tool. The question I keep getting: is that safe, or does the folder leak data?

Microsoft's own docs have a note on it: report files like visual.json or bookmarks.json "can be saved with data values from your semantic model". So I tested it. On the Contoso sample model, every test is the same: do one thing in Power BI Desktop, save, open the file.

What I found:

- **Slicer selections** are saved by name. Tick "Contoso, Ltd" and "Fabrikam, Inc.", save, and both names are in visual.json.
- **Select all** saves no names at all, just a flag. Easiest fix of the lot.
- **Search box text** is saved even when nothing is selected. Type a client's name, it's in the file.
- **Bookmarks** keep their own copy. Clear the slicer and the slicer's file is clean, but the bookmark still holds the name. The bookmark options (selected visuals, data off) don't change that.
- **Matrix +**: just expanding rows saves the names of the rows you opened.
- **Colouring one bar by hand** saves that category's name (a rule-based colour doesn't).
- **Column width** in a table is saved per value too.
- **Model files** hold no rows from your source. Two exceptions: "Enter data" tables (stored packed, not encrypted), and anything you type into a query, like a key or a name.
- **Connection info**: the server, database and tables are there. Your password is not.
- **The big one: .pbi\cache.abf.** This hidden file holds every row of every table. Open it as text and it looks like nothing; with a free tool you get the tables back.

So, is it safe? Yes, if you clean the folder first:

1. Clear slicers and filters (or use Select all)
2. Empty slicer search boxes
3. Collapse matrices
4. Colour by rule, not by hand
5. Clear bookmarks, then update them
6. Never share cache.abf: delete the .pbi folders from every copy you give away (and keep them out of git)

The test report is on GitHub if you want to try it yourself: https://github.com/pawelkulakowski/is-pbip-safe (the .pbix only, Contoso sample data).

r/PowerBI • • 1d ago

Question Resources to learn data modeling

7 Upvotes

What's a good resource to learn data modeling?


r/PowerBI • • 1d ago

Question Tried to install the new 2026-11-19 update (v2.159.1231.0), but it wants to "Repair" ?

9 Upvotes

I currently have the 2026-11-02 update (v2.159.1231.0) installed.

Is anyone else seeing the same? Seems like a botched release.

Link: Download Microsoft Power BI Desktop from Official Microsoft Download Center


r/PowerBI • • 2d ago

Feedback End to end column lineage in Measure Killer Free

40 Upvotes

For everyone who is not aware yet, I wanted to share that we released Measure Killer 3 recently bringing end to end column lineage to Power BI.

https://measurekiller.com/source-to-visual-lineage

This is available in the free version and shows you all data sources you are using in your model(s).

It follows every column through Power Query transformations down to every visual.

-You can track exactly where a measure gets its values from.
-Which source columns are used in a visual etc.
-Where the data for a source table flows (into which KPIs, pages, visuals etc)

We would appreciate it if you gave it a try and provided feedback.

Supported data sources: SQL Server, Azure SQL, Fabric WH/LH/DB, Snowflake, PostgreSQL, Databricks

Coming in the next version: Oracle, BigQuery


r/PowerBI • • 1d ago

Question Use AI agents safely in a highly regulated work env.

3 Upvotes

On my personal rig, I give Claude unrestricted terminal access and it crushes Power Platform builds. Since there's nothing critical on that machine, my worst-case recovery plan is just reinstalling Windows (no Docker or VMs needed).

​In my work environment, I restrict Claude to read-only Get- PowerShell commands for .pbip projects. Even without admin privileges, I’m not comfortable letting it run arbitrary PowerShell or Python scripts. How can I still get it to handle heavy lifting like page boilerplates, object grouping, and theme application safely?

Claude tends to create bash scripts and pythons to do boilerplates and builds and it borderline starts to hallucinate if you restrict it's tool usage.


r/PowerBI • • 2d ago

Discussion Do you struggle with report design?

10 Upvotes

I’ve seen so many Power BI reports that are great technically, but visually not so much.

Which makes sense, because being good at DAX and data modeling doesn’t automatically make you good at design.

I’m curious how you guys deal with this.
Do you spend a lot of time trying to make your reports look good?

What’s the hardest part for you? Layout, colors, spacing, choosing visuals, background?

Do you use any tools for design, like Figma, templates, themes, PP, AI? Or just do everything directly in Power BI?

Have you tried AI for report design? What do you think about the results?

Personally, I feel like AI-generated dashboards are starting to all look the same. You can almost immediately tell when something was made with AI. They might look nice, but there’s not much originality.

If you could make one thing about designing Power BI reports easier, what would it be?

Just curious to hear how others approach this.


r/PowerBI • • 1d ago

Discussion Publicación de metric views hacia PBI: pros, limitaciones y retos

Thumbnail reddit.com
1 Upvotes

r/PowerBI • • 2d ago

Discussion For people who struggled to learn DAX-what actually made it finally click?

67 Upvotes

I've been trying to get my head around DAX (especially CALCULATE and filter context) and watching 2-hour YouTube tutorials is putting me to sleep.

For those of you who went from Excel to Power BI: what did you actually use (or pay for) that worked? And what was the most frustrating part about how it's usually taught?


r/PowerBI • • 1d ago

Feedback Fabric Apps and Performance Optimization

Thumbnail
reddit.com
2 Upvotes

r/PowerBI • • 1d ago

Feedback Built a 12-Page Global Supply Chain & Logistics Control Room in Power BI (Light Canvas & Clean UI) — would love your feedback!

0 Upvotes

Following feedback on clean light-mode UI design, here is my 13-Page Global Supply Chain & Logistics Control Room built in Power BI using a light grey canvas (#F4F5F6) and crisp white visual cards.Key Modules Included:

  • Executive Control Center: Total Shipments, Freight Cost, Units Shipped, Delay Hours & What-If Scenario Slider
  • Route Optimization & Delay Analysis: Ocean Cargo, Air Freight & Road Transport delay matrix
  • Carrier & Fleet Performance: Comparing DHL, FedEx & UPS on-time delivery and risk scores
  • Warehouse Stock & Global Diagnostics Map: Real-time inventory levels and capacity gauges

Would love to hear your thoughts on the layout, color palette, and DAX structure!

"If anyone is looking for a ready-to-use .pbix template or needs a custom Power BI dashboard built for their business, feel free to send me a DM (Direct Message)!"


r/PowerBI • • 1d ago

Feedback Built a 6-Page Financial Performance, Cost Control & Ledger Audit Dashboard in Power BI — would love your feedback!

0 Upvotes
  • Here is another light-theme financial dashboard I built in Power BI for CFOs, finance teams, and business owners to track P&L, operational expenses, and transaction audits in one place.Key Highlights:

    • Executive Summary: Tracking Total Revenue ($13M), Net Profit Margin (30%), Operational Expenses ($2M), and monthly revenue trends.
    • Regional & Departmental Breakdown: Comparing performance across Middle East, North America, Europe, and Asia-Pacific.
    • Cost Center & Margin Analysis: Identifying overspending and tracking gross vs. net margins.
    • Transaction Audit Table: Detailed ledger view with COGS and conditional profit indicators.
  • Feedback on the color palette, layout, and visual hierarchy is always welcome!

"If anyone is looking for a ready-to-use .pbix template or needs a custom Power BI dashboard built for their business, feel free to send me a DM (Direct Message)!"


r/PowerBI • • 3d ago Bravo

Feedback My submission for Power BI Datawiz World Championship

Post image
233 Upvotes

r/PowerBI • • 1d ago

Feedback Built a 12-Page Global Supply Chain & Logistics Control Room in Power BI (Light Canvas & Clean UI) — would love your feedback!

1 Upvotes

Following feedback on clean light-mode UI design, here is my 12-Page Global Supply Chain & Logistics Control Room built in Power BI using a light grey canvas (#F4F5F6) and crisp white visual cards. Key Modules Included:

  • Executive Control Center: Total Shipments, Freight Cost, Units Shipped, Delay Hours & What-If Scenario Slider
  • Route Optimization & Delay Analysis: Ocean Cargo, Air Freight & Road Transport delay matrix
  • Carrier & Fleet Performance: Comparing DHL, FedEx & UPS on-time delivery and risk scores
  • Warehouse Stock & Global Diagnostics Map: Real-time inventory levels and capacity gauges

Would love to hear your thoughts on the layout, color palette, and DAX structure!

If anyone is looking for a ready-to-use .pbix template or needs a custom Power BI dashboard built for their business, feel free to send me a DM (Direct Message)!"


r/PowerBI • • 2d ago

Question Native BI matrices

4 Upvotes

Why are these so incredibly limited?

If I have 4 attributes in a matrix broken out by quarter (so 1Q26, 2Q26, etc. with the 4 attributes below) - there’s no way to draw a border so I can isolate quarterly impacts?

I want the user to be able to select a mix of periods but it will end up as just a giant wall of numbers with nothing splitting it up cleanly.

And this is work related so I can’t add any paid custom visuals


r/PowerBI • • 2d ago

Question Read Record Vs Table Join

Thumbnail reddit.com
1 Upvotes

r/PowerBI • • 2d ago Bravo

Feedback My Power BI Dataviz World Championship Round 1 entry, and a few techniques I learned along the way

14 Upvotes

I just submitted my Round 1 entry for the Power BI Dataviz World Championships 2027 and wanted to share it here, along with a few techniques and gotchas that might be useful even if you're not entering.

The brief: pick one of four hotel brands, review where it stands, and pitch a five-year investment plan to the Board. You get exactly two visible pages and only the provided dataset.

My entry: Goodnight Inn: Profitable, but Fragile.

https://community.fabric.microsoft.com/discussions/pbi_contestsgallery/goodnight-inn-profitable-but-fragile/5425412

Things I tried that worked well

  1. Chapters instead of more pages. With only two pages allowed, each page has four "chapters" driven by a bookmark navigator (Data off, selected visuals only). Every view stays uncluttered, and the report can still tell a longer story.
  2. A world map without a map visual. I used a scatter chart with longitude and latitude on the axes, fixed axis ranges, and a plot-area background image of the world drawn to exactly those ranges. It looks like a map but behaves like a native visual: tooltips, keyboard navigation and show-as-table all work.
  3. Headlines and alt text written in DAX. Every key message and every alt text is a measure, so when you change the region filter or the scenario, the text rewrites itself with the right numbers. Screen-reader users get the same story as everyone else.
  4. A scenario engine in DAX. A calculated monthly cash-flow table (project × scenario × delay × month) drives NPV, payback, break-even and cost of delay from a disconnected Low / Expected / High slicer.
  5. Accessibility as a design constraint. Alt text on everything, tab order in reading order, WCAG contrast checks, shapes and labels so colour is never the only signal, and a help panel inside the report.

Things that might save you time

Sort by column causing a circular dependency. A calculated band column that used CALCULATE depended on every other column in the table, including its own sort column. Rewriting both columns with FILTER + SUMX (no CALCULATE) fixed it.

RANKX returning "5 of 4". This came from tiny floating-point differences between the ranked value and the table values. Wrapping both sides in ROUND(…, 6) solved it.

Tab-order testing in Desktop is misleading. Text boxes still show the visual header "…" as a tab stop in edit mode, even when it's turned off. Test in Reading view in the service instead.

Fixed axis ranges break under filters. They look great for "All", then clip or flatten when someone filters to one region. Driving axis min and max with measures (fx) fixed it.

I'd really appreciate any feedback: what works, what's confusing, what you'd cut. And if you're entering too, drop your link and I'll happily look at yours.


r/PowerBI • • 2d ago

Question Query has exceeded available resources error

Thumbnail
gallery
4 Upvotes

Hi guys,

I have a peculiar case and I find it hard to wrap my head around it.

Here's the setup. I run a deployment pipeline in PBI service. The main setup is between UAT & PRD. I got a pro license.

I have a report with some complex DAX calculations. It's been running for a few months now. I've handled some of the usual issues including a capacity limit warning I've had a week ago and had to schedule less frequent refreshes & synch with other teams with whom we share the capacity to do the same.

Today, out of the blue, I got an error message about available resources on my main matrix tables and it does not load. I've had similar issues in the past and it's normally when too much data is presented or when the daxes are too complex to compute.

What was peculiar about the case today was :

- It does not show in the local pbix, it only shows in the PBI service

- In the PRD enviroment, it shows the matrix but it gives me the error message when I try to use one particular filter ( 1 out of the 6 options that is not the heaviest selection)

-The matrix shows the error straight away in UAT enviroment in PBI service without the use of the filter.

-There is another page which loads super fast locally (unlike the previous main one which takes a 5-10 seconds) but it completely fails with the same error in the PBI service.

-Both pages have a common underlying dax measure but there are also 2 other pages which work just fine with the same underlying dax.

I'm strugglying to understand what is the core issue. In my experience, I should focus on make the matrix simpler (less data or less complex measures) but the inconsistency between enviroments and the "randomness" of why some things failed and others did not is driving me crazy.

If you have an idea what's this about or if you can explain such behavior or have had similar issues, please share.

I have considered it could be caused by a few different things but I don't understand the inconsistency of it. I'll work on it again tomorrow..


r/PowerBI • • 2d ago

Feedback Head up Date picker will be the default date slicer from the November update

4 Upvotes

The Summary is here, but the update will be released next week (I completely missed this when I was checking out the summary and was confused why I did not see the November update in the Desktop)

Power BI November 2026 Feature Summary:
Default slicer mode for dates is now “date picker” (Generally Available)

When you add a date column to the Slicer visual, it now starts in Date picker mode, so you can offer flexible date filtering without changing the style first. Readers can choose a specific date or range using the calendar or slider, or use relative selections anchored to today, the first date, or the last date in your data. You can still choose another style under Slicer settings > Options > Style in the Format pane.

I like it overall, but when it is most useful and easy for users, it takes up much more space on the page than the current default one.

What do you think?
Will you straight away go to settings and change it back? )


r/PowerBI • • 2d ago

Question How to avoid measure bloat and unnecessary/long calculations?

6 Upvotes

My company recently switched from our data being stored in a file system with no relationships to a proper, typical star schema (with a semantic model on top). There are some legacy dashboard type reports I am porting into PBI, but quickly realized I was becoming overwhelmed with all the measures I was creating, creating measures too detailed where they couldn't be reused, having measures which run very slow, etc.

Been searching around for various help/options (Performance Analyzer, DAX Studio, Measure Killer, Calculation Groups, etc.) but I am not confident those will help without having a better basic approach/view on what the path is to begin with. Any thoughts/tips?

For example, I have a matrix which displays ~10 measures for a row grouping. Takes about 50 seconds to refresh. The underlying data set is ~60k rows, maybe 30 columns max. Measures are relatively straightforward (summations, Averages, Weighted Averages, and some percentages of total). I am positive it shouldn't take that long, which leads me to knowing one (or more) of the measures is at fault, but overwhelmed to determine where/why/how to fix. Could be that each measure has to check if the row is a part of the necessary population (which in itself is another measure, think checking if "active") and then performs the actual calculation measure on top of the resulting rows, but I have no idea.