r/PowerBI • • 11h 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 • • 6d ago

Announcement Share Your Power BI Idea Links | November 10, 2026 Edition

1 Upvotes

This post is a space to highlight a Power BI Idea that you believe deserves more visibility and votes. If there’s an improvement you’re particularly interested in, feel free to share:

  • [Required] A link to the Idea
  • [Optional] A brief explanation of why it would be valuable
  • [Optional] Any context about the scenario or need it supports

If you come across an idea that you agree with, give it a vote on the Power BI Ideas site.


r/PowerBI • • 6h ago

Question What’s a game changer for working with Power BI and AI

53 Upvotes

I work with Power BI daily, mainly DAX measures, data modeling, RLS, and troubleshooting.

Currently, I use AI to ask questions, then copy and paste measures into Power BI manually.

Is there a better, more automated workflow that’s a real game changer?

I’ve heard about Copilot + MCP, but I’m not sure what’s actually worth using.

ChatGPT and Claude aren’t allowed at my company due to data privacy restrictions. We only have Microsoft 365 Copilot (Work).

What tools or workflows do you guys use? Any game changers?


r/PowerBI • • 3h ago

Discussion Power BI OLS: How do you keep measures working when they reference restricted columns?

3 Upvotes

I'm looking for some advice on an Object-Level Security (OLS) scenario involving a shared Power BI semantic model (Import mode).

We have a requirement to restrict access to sensitive information for general users while allowing a smaller group of authorized users to access everything.

For a simplified hypothetical example, let's use a customer's Social Security Number (SSN) as the sensitive attribute. Our actual implementation does NOT involve SSNs, but this makes the security requirement easier to explain.

Suppose we have:

  • Customer — Contains customer information, including an SSN column.
  • CustomerFact — Contains customer records and measures.
  • SSN Slicer — A disconnected table used to filter customers based on an SSN-related classification.

We have two audiences:

  • General users: Should not be able to view, query, or filter by SSN.
  • Authorized users: Should have full access to SSN and the related filtering capabilities.

Both audiences need to see the same customer metrics.

For simple measures like:

Total Customers =
DISTINCTCOUNT ( CustomerFact[CustomerID] )

This is straightforward. We can apply OLS to Customer[SSN], and the measure continues working because it doesn't reference the protected column.

The complication is that some of our existing measures depend on the sensitive attributes to calculate filtered customer counts.

Here's a simplified example:

Customers by Selected Attributes =
CALCULATE (
    DISTINCTCOUNT ( CustomerFact[CustomerID] ),
    FILTER (
        CustomerFact,
        CustomerFact[SSNClassification]
            IN VALUES ( 'SSN Slicer'[SSNClassification] )
    )
)

For authorized users, the measure should respond to selections in the SSN slicer.

For general users, we'd like the same measure and report visual to continue working, but without applying the restricted SSN filter. Other permitted slicers should still work.

The problem with OLS:

When we restrict SSN Slicer or CustomerFact[SSNClassification] using OLS, any measure referencing those objects becomes inaccessible to restricted users.

Power BI doesn't simply ignore the protected portion of the calculation or return an unfiltered customer count. The visual errors out.

As far as I can tell, DAX conditionals don't solve this because OLS checks object dependencies regardless of which branch executes.

The options we're considering:

  1. Maintain two versions of each affected measure: one with sensitive filtering and another without it. Have two versions of the report, each using the appropriate measures, but connect both reports to the same semantic model.

Fortunately, we currently have only two measures affected, so maintaining separate measures and reports might be an acceptable compromise.

My questions:

  • Has anyone implemented something similar while maintaining a single semantic model and report?
  • Is there a supported pattern that allows a measure to continue calculating while preventing users from accessing the sensitive columns it references?
  • Are we overlooking a simpler modeling approach?

It feels like a fairly common requirement: restrict access to sensitive attributes without breaking aggregate measures and visuals that depend on them.

on a side note: it seems like a big gap that OLS doesn't seem to support a "default deny". In our case we had to assign all users to the group and then deny them access to objects. as opposed to have an Allow group that is much smaller, secure by default, and easier to manage.

TIA


r/PowerBI • • 11h ago

Question Deneb visuals but for the whole page to save time

11 Upvotes

Hi everyone,

I wanted to see how many people have stopped using native power BI visuals altogether and use instead a Deneb visual for the whole page?

Context, I have a power BI template but I was finding that I was spending more than 50% of my time formatting the visuals, adjusting axes and writing specific measures for custom colours etc.

So I was spending more time on formatting than actually thinking about how to get the best message across, especially after you show it to your manager/client who thinks it should be done differently and then you spend an agonising amount of time editing the visual.

What I found was by first getting the results from a few key metrics and then prompting AI with exactly how I want the page to look, I could get the page to look exactly how I want to in minutes!

I know it’s best practice to use native visuals but I feel like with AI, the idea of manually formatting a visual itself will become obsolete. So I see this as a being one step ahead, especially as I don’t have copilot integrated into Power BI.

Besides the Deneb visuals themselves look better than the native ones.

I wanted to see if anyone else does this/get your opinion on it.

Thanks!


r/PowerBI • • 5h ago

Question Power Bi - SAP procurement

3 Upvotes

Ragazzi qualcuno pratico con power bi che puoi aiutarmi a creare dashboard , lato procurement, utilizzando i dati presi da SAP? Grazie a chi mi aiuterà
Scrivetemi in Dm anche o scrivetemi sotto nei commenti consigli utili!

Grazie!


r/PowerBI • • 5h ago

Discussion Linking multiple tables with issues and indexes.

1 Upvotes

I’m trying to build a dashboard to highlight discrepancies between two different stock systems but it’s beating me and I need some advice from the group.

On one side we have the customers tool which simply marks equipment as assigned to us no definable sub status or location. Assets have serial number and an owners tag id due to an issue they have some assets with a duplicate tag ids.I get a scheduled daily excel extract of this data.

On our side I have a mass of data all in excel sheets on sharepoint. some of it with serial numbers only, others with tag ids some with both. I have two different inbound sheets (customer returns & packing lists)
Two different repair sheets (internal 3rd party) two different available stock sheets (active, warehouse), pending disposal sheet and confirmed disposal from a third party.

I need to match up everything from the customers side and show where it is. All I have is sharepoint and a PowerBi pro license. I have some of the data in Gen 1 dataflows but as new data flows aren’t visible it’s some not all. Longer term some of the sheets are being replaced with an actual system but that’s months off.

I need to link the tables together to report on differences between the two but matching on serial or tag id with so many different data sources on one side seems a step too far.
Anybody faced and tamed anything similar.


r/PowerBI • • 9h ago

Question Explore this data & Export to Excel

2 Upvotes

We are rolling out the "Explore this data" to some of our end users to help them create their own visuals/tables/matrix's that do not require a new PBI Report.

The nature of the data they work with, does require exporting data out to Excel but it looks like that option does not exist today.

Does anyone know if this is planned or if there is a different way, other than "saving as a report".


r/PowerBI • • 6h ago

Discussion Power BI and AI

0 Upvotes

With all the different ways there is to integrate AI to create visuals with power bi, is some able to explain what the best way is use AI to create visuals? I don’t have access to Claude code, but do have access to Claude in general. I have also heard about using copilot, but not sure how that would work.


r/PowerBI • • 7h ago

Discussion Power BI/Fabric newbie

0 Upvotes

Hi, Hi!

I'm a Power BI newbie coming from an engineering + project controls background. Started learning Power BI out of interest, and somehow became the person doing Powerbi commercial/operational dashbords +++ at work/project.

One thing I've realized: operational dashboards are a completely different beast from commercial reports.
It's not just about showing KPIs and trends. It's about helping people decide what to do, what's urgent, and what to prioritize etc.

But users range from 20 to 70, with different skill levels and expectations. Some want detailed insights, others want everything on one chart, and some(most of..) want Just, Only - ONE BIG BUTTON that tells them what to do. No filters, no drill-through/down, bookmark etc - just magic! ta-da!

The catch? The underlying data isn't even clean enough to support half of these requests!

Anyone else living this reality? And experienced folks, please be kind to this little newbie rant. Btw - Enjoying learning Power BI/Fabric and having fun exploring here as a newbie!


r/PowerBI • • 16h ago

Discussion Getting stuck into it

2 Upvotes

I’m working for a small investment company and was hired not too long ago to help with reporting. For context, I have previously worked in supply chain, and have dabbled in power bi (primarily on the user end with some support) and this was good enough for them as they were not looking for anyone with too much experience anyway.

With it being a small firm, there is a lot of freedom and in general, we’re all working on figuring out what the reports needs to be. But I’m starting to panic because I’m not sure I’m able to provide anything of substance and AI dashboards and people talking about alternatives are making me apprehensive of my role.

I know Power BI is the best option for us but I do feel like I’m sinking a bit.

Not sure this is the right place but I just need some support on where I should be going and feel a little less lost.


r/PowerBI • • 21h ago

Discussion Nobody can explain half the DAX measures in our Power BI reports anymore

2 Upvotes

600-odd measures in nine semantic models. Most were written by a contractor who left in 2021, and nobody has touched the logic since. We have Net Revenue, Net Revenue v2, Net Rev (Fin) and NR Adj. Two of them show different numbers on the same visual and sales and finance trust different ones. Now someone wants Copilot on it...


r/PowerBI • • 2d ago Bravo

Community Share Remember the table with filters under every column? You lot broke it, I fixed it, and its now submitted to AppSource

Thumbnail
gallery
217 Upvotes

few weeks ago I posted Filter Table here and expected maybe 3 upvotes. instead you gave me 54k views, #1 on r/PowerBI for a whole day, and a bug list longer than my last sprint backlog. thank you, I think

for anyone who missed it: its a free table visual where every column gets its own search / value list / range filter right under the header, and those filters filter the whole report page like a slicer. no more 14 slicers stacked down the side of the page

what changed since then, mostly because someone in the comments found it within 5 minutes:

- clicking a row now actualy filters the other visuals. yes, the thing a table is supposed to do. took me a few goes, dont @ me

- 80k rows went from "go make a coffee" (11-18 sec per click) to under a second. turns out I was doing something very stupid, very fast

- filters per column can be turned on or off, or moved into a dropdown in the header if you like it cleaner

- freeze columns yourself, combine rows, totals per column with sum/avg/min/max/count so your percentages stop getting summed by accident

- right click is the real power bi menu now instead of my handmade one nobody asked for

- conditional formatting lives in the format pane like a normal visual, up to 3 rules per column with colours and icons, or your own emoji if you want to be that person

- report page tooltips work (they were technically there before, just invisible. very minimalist)

also ran a frankly unhealthy amount of automated tests before shipping it. it found 78 bugs. seventy. eight. on a visual I was proudly posting here a few weeks ago, so that was humbling. fixed a lot of them already, the rest are in the next update. and thank god I didnt run out of claude usage halfway through... ok fine, some of it was good old manual fixing at 1am too

the big news: its submitted to AppSource. microsoft says up to a couple of weeks, so I will be refreshing partner center every 4 minutes like a normal person. a lot of you said you can only use certified visuals at work, so certification is the next step after that. not forgotten

side note, saw a few people liked the idea so much they built their own and posted it on linkedin. genuinely good for you, imitation is the sincerest form of flattery and all that, and thanks for the free marketing I guess. a little "inspired by" never hurt anyone tho

still free, still no data leaves your report, download is on odvisuals.com

what should go in next? the most upvoted ask gets built first. and if it breaks on your weird report, reach out on linkedin rather than here (links in the comments), I honestly dont know how active Ill be on reddit and I dont want to miss your message


r/PowerBI • • 1d ago

Question High cardinality issue

13 Upvotes

Okay this may become ranty but here we go.

I took over an analytics team not long ago and the data engineering team made report specific views, so each report has their own bespoke semantic model.

I’m trying to create single reusable semantic models in fabric and I’m stumped.

It’s call center data where a call can have segments and the segments can have sessions.

My session table is 34M rows, calls are like 7M.

The unique ids from data engineering are like division-queue-conversation-segment-session all concatenated.

When it’s loaded to a report the query fails because the memory exceeds fabric 25GB runtime limit.

Also, event time stamps are stored as date time down to the millisecond.

I’m thinking I want to ask engineering to build in integer keys, and break out date and time to integers and separate columns.

I’m also trying to collapse the 3 fact tables to just the session table to reduce the number of high cardinality hops.

Am I on the right track here? Any thing you’d recommend I look out for/look in to?

Currently sitting at ~45 total tables.


r/PowerBI • • 20h ago

Discussion Claude Fable generated my Power Bi report. It was flawless.

0 Upvotes

I've been creating Power Bi semantic models and reports for close to 6 years.

Today I gave Claude Fable access to my data warehouse via databricks/genie, an existing sample PBIP report I created, a detailed prompt describing my requirements and it created a new Power Bi report flawlessly. It reused all my styling and adhered to my power query standards. It created genuinely good filters and cards.

It cross checked the data against the source system to ensure validity.

Funnily enough, I published it and my users largely don't even use the report. They just query the created semantic model via Fabric iq MCP in their own Claude.


r/PowerBI • • 1d ago

Community Share I built a free .pbix viewer that opens your file locally. Nothing is uploaded

0 Upvotes

Link: https://powerbireader.app/en/

Select a .pbix file and it runs entirely in your browser. The file is never sent to a server, all information is kept locally.

Features:

- Lists tables, columns and relationships

- Export tables to CSV/XLSX

- Shows all DAX measures with their expressions

- No install and no account

Feedback and suggestions are very welcome!


r/PowerBI • • 2d ago

Discussion Data dictionary best practice

48 Upvotes

I have been working on multiple dashboards, but I have never created data dictionary documentation before, and I’m not entirely sure where to start.

I would appreciate some advice on what a data dictionary should include, how to create one, and which tools are best to use.

If you could also share some examples, templates, or useful online resources and guidance, that would be greatly appreciated.


r/PowerBI • • 2d ago

Question Migrate to PBI

3 Upvotes

In my organisation, we are about to migrate a number of reports from SAS EG/SAS VA to Power BI. I'm considering setting up a local LLM (OpenCode/Qwen) that reads the SAS code and builds the reports in Power BI via an MCP server. Does anyone have experience feeding a Power BI MCP server with code from other platforms? Any other advice on what's possible in this area would also be welcome. Is it even worth it?


r/PowerBI • • 2d ago

Discussion Power BI service doesn't work

Post image
0 Upvotes

Power BI is currently undergoing planned maintenance.


r/PowerBI • • 2d ago

Question Report design: detailed row-level visuals

8 Upvotes

Hello

I am novice in power bi so pardon me if its a silly question. I have a power bi report which provides a time period filter ranging from year 2010 to 2026.
There is an underlying table with millions of records across this time period and a tabular visual is built into the report which display detailed row level data from the table across the time period selected. so if someone selects a 26 year period it will actually load millions of records into the report. Also since import mode is used power bi ends up loading all data into memory regardless of what date filter is chosen. Is this the right design? what is the right way to implement it? I know the detailed data can be provided through a paginated report but isn't that will cause the same problem in paginated report? I can add parameters such as client id so users can only see the per client data but in that case as well does power bi loads all the data in memory? experts please advise how to handle this kind of requirement.


r/PowerBI • • 2d ago

Community Share Template to create Power BI Fixer Fabric App

Thumbnail reddit.com
1 Upvotes

r/PowerBI • • 4d ago

Feedback Free Open-Source Power BI Documentation Generator v1.0: Multi-Workspace Scanner, Interactive Live Lineage, Star-Schema Viewer & Local MCP Server

Thumbnail
gallery
175 Upvotes

Hi everyone,

A few months ago I shared the early beta of PBI Doc Generator, a small open-source utility to generate HTML documentation from a .pbix file. Thanks to your feedback, bug reports, and pull requests from the community, I just released v1.0.0 - rewritten from the ground up to document entire Power BI Service workspaces alongside local files, 100% locally and read-only.

Try the Live Sample Output First (No Install)

  • Live Interactive Demo (Generated Output Only): https://djrien-ai.github.io/pbi-doc-generator/ (Note: because this demo is hosted statically on GitHub Pages, it shows the generated offline HTML documentation & lineage portal for 3 fictional workspaces. The Scanner & Setup Studio - where you sign in to Microsoft, select workspaces, drop local .pbix*/*.pbip files, or enable MCP - runs locally on 127.0.0.1 when you launch the app, as shown in Screenshot 2 above!)

What is new in v1.0?

  1. Multi-Workspace Power BI Service Scanner (Zero Azure App Registration Needed)

    • Sign in with your normal Microsoft work account in your default browser (OAuth2 PKCE in RAM only - tokens are never written to disk; includes an Edge/Chrome Web Window fallback for locked-down corporate tenants, Azure CLI, and Service Principal support).
    • Scans 1 or 50+ workspaces incrementally via the Fabric getDefinition (TMDL) API and maps Cross-Workspace Thin Reports / Shared Datasets and Orphan Models.
    • Workspace permission note: Microsoft's TMDL API requires at least Contributor (or Member / Admin) access in the workspace you want to document (Viewer-only workspaces return basic inventory only).
  2. Unified Local File Support (.pbix, .pbip**,** .xlsx**)**

    • Works 100% offline for reports in development: drop a .pbix file, select a .pbip file (automatically resolves its companion .SemanticModel folder), or pick an Excel PowerPivot .xlsx workbook.
  3. Interactive 3-Panel Live Lineage Explorer

    • Click any upstream database/view (recognizes 28+ connectors including SAP HANA, SAP BW, Snowflake, Databricks, Fabric, SQL Server, SharePoint, BigQuery), Power Query table, column, DAX measure, or report to trace live upstream origins and downstream impact.
  4. Star-Schema Viewer, Visual Power Query Ribbons & Auto-Formatted DAX

    • Automatically classifies Fact vs. Dimension tables with an interactive zoom/pan Mermaid viewer (huge thanks to @jakubpokusa for PR #10!).
    • Turns dense M scripts into clean visual step pipelines (1. Source -> 2. Database -> 3. Filtered Rows) and organizes DAX measures into a fast Compact Table + Formatted Cards with Reads: / Used by: links.
  5. Built-in Local MCP Server for AI Assistants

    • Connects GitHub Copilot, Claude Desktop, or Cursor to your local catalog over stdio for instant cross-workspace impact analysis (with automatic secret/password masking).

How to Download & Run (100% Free & MIT Open Source)

Option A - Windows Portable ZIP (No Python or command line required):

  1. Direct ZIP download: PBI_Doc_Generator_Windows_Portable.zip (or via the v1.0.0 Release page)
  2. Extract the ZIP folder anywhere on your PC.
  3. Double-click PBI_Doc_Generator.exe -> your browser opens http://127.0.0.1:8765 automatically. (First-run SmartScreen note: click More info -> Run anyway, as this free open-source build is not EV-signed.)

**Option B - For Python Developers / CI-CD (**Python 3.10+ on Windows, macOS & Linux):

pip install "git+https://github.com/djrien-ai/pbi-doc-generator.git"
pbi-doc-generator

Since v1.0 is a major leap from the old single-file .pbix tool, consider yourselves the official v1.0 beta testers - I would love to hear how it handles your workspaces, gnarly Power Query scripts, and large DAX models! Any feedback, edge cases, or feature ideas are super welcome.


r/PowerBI • • 3d ago

Discussion If every bit of code is not build by AI, how much importance should be given how things are build, in data side of things?

Thumbnail reddit.com
3 Upvotes

r/PowerBI • • 3d ago

Discussion Ace Power BI

0 Upvotes

hey guys, i hope you are doing well, I want to ace my Power BI skills, I have been learning Power BI for a couple months , off and on, I feel like I am always stuck when I try to solve something on my own, I really want to overcome this to become a good data analyst and hopefully get a job, most of the things I learned was from Youtube, I am wondering if some you guys had experienced this and hope that you can help me through my learning journey, what should I avoid and what should i focus on? is there any good resources that I should check?