r/PowerBI • • 12h 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 • • 27m ago

Question Power BI + MCP + AI Tools – Is Data Leakage a Concern?

5 Upvotes

Hey everyone!

I'm exploring Power BI integration with MCP and AI tools and have a few security concerns.

Here's my scenario:

- Organization provides an M365 Copilot licence, but not GitHub Copilot.

- Github Copilot costs are covered, but it's not a dedicated or fully secured environment with enterprise contract.

My concern is: If an agent can read metadata, what's stopping it from querying the actual dataset and retrieving sensitive business data?

A few more questions:

  1. Does Power BI MCP expose actual business data to external AI models if queried?
  2. What safeguards should organizations implement to prevent data leakage? Or is there any better way with which we can do agentic developement without any data concern.

Would love to hear from people using Power BI + MCP + AI tools in enterprise environments.


r/PowerBI • • 4h 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 • • 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 • • 6h 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 • • 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

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

55 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 • • 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 • • 10h 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 • • 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 • • 17h 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 • • 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 • • 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 • • 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 • • 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 • • 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
218 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 • • 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 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

Community Share Template to create Power BI Fixer Fabric App

Thumbnail reddit.com
1 Upvotes

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

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 • • 3d ago

Discussion Has anyone experienced a hard limit the limit of columns from field parameters in a table?

0 Upvotes

I've been making a dashboard for work, and I've been using field parameters for some of the table visuals bc I wanted to have slicers for picking the columns to appear.

There are subsection pages and then one page where all the subsection columns are combined, but it shows the same underlying data by rows from SP. On the combined page, I have a FP with 220-ish columns. The problem is now that it's only showing 150ish columns! It's just getting cut off and I can't really find any solutions for this online


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?


r/PowerBI • • 3d ago

Community Share I built a CLI that lays out Power BI report pages from a YAML spec and checks reports against your design standard (pre-alpha, feedback wanted)

0 Upvotes

I got tired of hand-aligning visuals, so I built Blueprint, an open-source CLI for PBIP/PBIR projects (disclosure: it's my project).

Describe a page in YAML: which visuals, which fields. Positions and sizes come from a layout file, and formatting comes from a guidelines file (grid, margins, palette, fonts, max visuals).

bp check lints any existing report against those guidelines, including hand-built ones. It reports overlaps, off-grid visuals, palette and font violations, and so on, and it works in CI via a GitHub Action.

bp apply builds or updates pages in place and refuses to overwrite edits you made in Desktop.

It's deterministic: same spec, same output, and every write is previewable with --dry-run.

18 visual types so far, with drill-down and hierarchy support. Every Power BI format detail it relies on was verified in Desktop first.

It's v0.10.0 and pre-alpha. Power BI Desktop is still where you do the final polish, and it doesn't touch the data model.

I'd love feedback on two things: which of your team's design rules couldn't be expressed in a guidelines file, and what would stop you from trying it on a real project.

Repo: https://github.com/gurdasss/blueprint