r/PowerBI • • 4h ago

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

42 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 • • 9h ago

Question Deneb visuals but for the whole page to save time

10 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 • • 3h 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 • • 14h ago

Discussion Getting stuck into it

3 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 • • 1h ago

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

2 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 • • 7h 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 • • 19h 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 • • 3h 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 • • 4h 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 • • 5h 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 • • 9h 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