r/PowerBI • • 2d 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 • • 17d 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 • • 7h ago

Community Share I built a public government data website on Fabric F2: 500+ Lakehouse and Warehouse objects, Python-generated pages, and it’s been great

Thumbnail
reddit.com
0 Upvotes

r/PowerBI • • 11h ago

Question Rayfin Apps in Power BI Desktop

Thumbnail reddit.com
1 Upvotes

r/PowerBI • • 1d ago

Discussion HTML Dashboard vs Power-BI with HTML Visuals?

8 Upvotes

I’m in charge of building dashboards in my current role. I’ve been using it for quite some time, but am completely self taught and have no other peers that really use it as much as I do, so I’m kind of isolated in that regard.

I’m currently stuck between the choice of using power-bi with custom html visuals vs the idea of using the sharepoint API to connect our data directly to an HTML dashboard.

For context: my team doesn’t really use the actual underlying data modeling aspects of power-bi to their full ability, as in no RLS, no managing the semantic model and who sees what, it’s really just a fancy dynamic power point. We mostly use them to take all of our Excel scenario analysis models that live on sharepoint and visualize them for our stakeholders, including the financial impact behind these scenarios.

A big sticking point is also fast refresh times. Currently we use power automate to trigger semantic model refreshes when there’s a modification to the excel models on sharepoint. This seems to do the trick, but I’m aware you can make html poll the API every minute, which should suffice.

Our stakeholders are also very keen on the idea of using power-bi for slides. I know there’s an actual Microsoft add-in for this, but for whatever reason we aren’t allowed to get it, so we’re stuck with the kind of low res, static image slide experts. On the flip side, I already made an html tool that lets us export native, high res slides that I currently manually feed the data to and am currently toying with the idea of moving over all visuals to just one html dashboard.

Tl;dr: I am the only power bi user on my team and want to know if I should switch to html with a sharepoint api, or stick with power bi with custom html visuals.


r/PowerBI • • 1d ago

Question Tracking which report pages each user views in Power BI Service

20 Upvotes

Hi everyone!

I'm trying to find a way to track user activity within a Power BI report published to Power BI Service.

More specifically, I'd like to know:

Which users access each report.

Which specific report pages each user visits.

How many times each user views a particular page.

Ideally, how much time users spend on each page.

I've been using the built-in Usage Metrics report, but it only provides high-level information, such as whether a user accessed a report and the number of page views. It doesn't seem to show exactly which pages were visited by each individual user.

Is there any way to get this level of detail within Power BI Service? Perhaps through the Power BI REST API, Audit Logs, or another approach?

Ideally, I'd like to track all this within the same Power BI environment, without having to rely on an external analytics tool.

Has anyone implemented something similar?

Thanks in advance!


r/PowerBI • • 9h ago

Certification PL 300 Certification

0 Upvotes

How difficult is to crack power bi PL300 certification and how much does it cost ? I already know power bi desktop but power bi services I have to go through a bit ?


r/PowerBI • • 1d ago

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

31 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 • • 1d ago

Discussion New Jobs Posted in Monthly Job Post

4 Upvotes

I've had recruiters reach out to me over the last few days with job postings. I'm not in the market right now.

https://www.reddit.com/r/PowerBI/comments/1xl3ugx/november_2026_job_opportunities/

u/itsnotaboutthecell - can you pin the November job post?


r/PowerBI • • 1d ago

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

98 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 • • 1d ago

Question Help with refresh error: The data provider was unable to convert the value '' from the source data type 'VT_BSTR' to the expected data type 'VT_I8'

0 Upvotes

Failure details: The following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table 'X' column 'Y'. The data provider was unable to convert the value '' from the source data type 'VT_BSTR' to the expected data type 'VT_I8'. Please check the column data types in the data model and data source and ensure that the data types are compatible. The current operation was cancelled because another operation in the transaction failed. The operation was canceled.. The exception was raised by the IDbCommand interface. The command has been canceled.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

I got this error message. This is for my small company which feeds off an excel spreadsheet. I went inside column Y and I checked no string all integers. Any help would be appreciated! Never had this issue before.


r/PowerBI • • 1d ago

Question "Apply Changes" bug is back, with the 2026-11-02 update (v2.159.1231.0) ?

5 Upvotes

Since installing this version a few days ago, I seem to have run into the old "Apply Changes" bug. I say this because I got the "Apply Changes" message when reopening two separate projects on two separate days. So "user error" seems a bit unlikely. Could've sworn I saved both projects tidily i.e. with all query changes applied.

Is anyone else seeing this?

Both were PBIX file format.


r/PowerBI • • 1d ago

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

6 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 • • 1d ago

Question DBT column description to semantic model column description sync

2 Upvotes

I want to be able to use the PBI mcp so users can ask natural language questions about reports/questions in general, but to make it work well you need the semantic models to have column level descriptions. I’m using Redshift/DBT, so my column descriptions live in yaml files. To sync the descriptions to the semantic models via CI/CD, it seems like I would need to have the pbib files in Git and use something like fabric-cicd, but that would require analysts to use git for any changes they make to the semantic model (measure changes is the biggest thing). Is there some option to make this easy that I’m missing?


r/PowerBI • • 2d ago

Question Deneb visuals but for the whole page to save time

17 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 • • 1d ago

Question Power Bi - SAP procurement

4 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 • • 1d ago

Discussion GM using PowerBI

0 Upvotes

I’m the GM. I recently started at a new company that uses SAP, and it’s a version that was forced upon our group over a decade ago. I have zero SAP experience. We’re in the materials distribution market. I’ve found implementing PowerBI from scratch to be a better experience for my role leading our S&OP. Unfortunately, I’m not allowed to connect SAP directly to PowerBI, so I have to run the various reports and then refresh. My goal is to be able to refresh and share some of these reports with my sales team. I’m a total newbie but have managed to get all of the behind the scenes legwork done except sharing the work I’ve put in to benefit my team. Is there a way to share the report where the team can engage with the various matrix’s or tables with a read-only level of visibility? My goal is to give inside and outside sales a detailed view of sales and inventories; i.e, Months on hand, sales volume over each of the last 6 months, inbound material, and projected sales to provide macro and micro visibility which is almost impossible to get from our SAP.

Does anyone have any ideas on how to best share my information?

Pardon my ignorance. Just a new guy trying to make people’s jobs easier and less manual.


r/PowerBI • • 1d ago

Discussion I used to work on the Power BI team. Here are my thoughts on the future

Thumbnail
baakwu.com
0 Upvotes

r/PowerBI • • 1d ago

Discussion Power BI/Fabric newbie

2 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 • • 1d 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 • • 1d 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 • • 2d ago

Question Explore this data & Export to Excel

0 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 • • 2d 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 • • 2d ago

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

3 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...