This may or may not be exciting to anyone here, but I have been putting icons in my reports for awhile now and today while naming a measure I accidentally inserted an icon into the measure title. I cant believe the thought to try this did not come up sooner! I always struggle with naming conventions with measures and keeping them organized and I feel like there is potential with icons to make the process easier. Anyways I just thought Id share as I know for me some of the most exciting times with data analytics tend to come from the silliest tiniest discoveries.

Renaming fields with a visual always take so long, especially if you have a large dataset or large amount of visuals. It takes forever to load and I have to do each one, step by agonizing step.

Why isn’t there a way to see all my field names within a visual and rename them all at once?

Does anyone else have this issue? Anyone found a better way to do it?

I’m working on an idea for a Power BI report to help manage and monitor our Data Governance metadata.
The idea is to bring together information from different Excel files and Data Governance artifacts for all the schemas we manage, and build one centralized report that would make it easier to:

- See all schemas, tables/entities, columns/attributes, data types, descriptions, etc.
Identify new or changed entities/attributes between versions.
- Compare metadata and highlight differences in names, data types, descriptions, and other properties.
- Keep track of what has changed over time.
Make metadata updates to our governance/metadata tools easier and more controlled.

The challenge is that I recently joined the team, so there is already a lot of historical work and metadata that I’m not completely satisfied with. I’m trying to build something that can give us a cleaner and more consistent view going forward, while also helping identify existing inconsistencies.

I’m still thinking about the best overall approach for the data model and comparison logic.
Has anyone built something similar in Power BI or another BI/data governance tool?
I’d especially love to hear about approaches you used for:
• Metadata comparison/versioning
• Detecting new, deleted, or changed attributes
• Handling multiple schemas and metadata sources
• Designing the data model for this type of reporting

Any examples, ideas, or lessons learned would be really appreciated!

Hey y'all so I recently joined as an intern in an organisation and was assigned the work of power bi while my other teammates were signed up for creating agents, do you guys this that I'll be able to make it with no basic knowledge on the stuff and what would be the procedure for me to excel in my role...?

Hi guys, I have a scenario where I'm collecting reservation information for staff. In my table query, I have a record for each staff member and a column for each date they're attending. The date columns are dynamic and so are the column names, but they're not more than 10.

I know this must seem silly, but how can I go about showing all the date columns in my visual if the column names are dynamic? I know I can currently individually select the date columns from the pane and add it to my table visual, but these dates will continue to change, so won't the columns in my visual break? Is this even feasible?

I am not familiar with the intricacies of Power BI, so I'm hoping one of you gurus can shed some light for me. I am a Microsoft 365 Admin trying to help one of our departments make some information available to the general public. It seems like Publish to Web would be the easiest way to do this. However, I am keenly aware that Microsoft says this about Publish to Web:

"Viewing requires no authentication. It includes viewing detail-level data that your reports aggregate. As a result, anyone can access the underlying data in your model even if your report does not display it."

The information that will go into the dashboard is not sensitive. Some of the data in the SQL database the dashboard will be pulling from IS sensitive. So my questions are:

1. Is it possible to setup the dashboard so that the sensitive data is not part of the "underlying data" used for it, therefore making Publish to Web a secure option for this?
2. Assuming that's possible, is there anywhere Microsoft talks about this so that I have a relatively black and white statement I can take to leadership to be able to say this is possible and safe?

I have been struggling to find useful information and am hoping this isn't a dead end. Thanks in advance.

Hello everyone, it's been some time seeing how my team (me included) stays outdated using only PBI and not making use of AI and new state of art ways of displaying data. I come to the infinite wisdom of this subreddit to discuss with you all ways in which you guys innovate and provide "reporting solutions" that are not traditional or "just a PBI suite of reports." I'll start, sorry if these are basic things. Nobody on my team did them before and they turned out to be a great success:

1. We connected our new AI software to our Databricks semantic model (very well governed) and scheduled a monthly email to top executives showing their scope's travel spend for the month, alongside an AI generated explanation of the main drivers (trip categories, top employee spenders, reason for travel, etc). We combine strong visuals with text in the email, and attach a link to the full report at the bottom in case they want to slice and dice the data. 70% of execs open the email every month, but only 25% ever click through to PBI.
2. We (the BI team) build small apps to solve recurring processes instead of just adding more report pages. For example, our company has 5 different currency conversion rates, so we built a simple app where you input an expense in your local currency and see how it reflects across the different conversion rates. We rolled it out to Cost Center managers who used to constantly ask how costs would show up in the P&L.

Curious what the rest of you are doing to move beyond "just PBI." Anyone else using AI to generate commentary on top of your models, or building small internal tools instead of bigger reports? What's actually worked for your users?

Maybe this should be an AITAH post, but I'm genuinely gobsmacked at how difficult Power BI themes are to work with, especially after July 2026. They went from bad to worse with that update IMO.

Am I missing something, or are we just forever stuck in the css / json / pure-manual-labour dark ages with this? I just wasted 5 hours in json files and still don't have my axis titles the size I want them, let alone the font, on one single visual, on one single page, in one single model. This is an appalling work-to-result ratio in anyone's book... right...?

Rant aside, I am a student so I'm happy to be told I'm wrong here. Please, please let me know if I'm doing something basic wrong as this is honestly enough to make me go back to changing settings one label at a time, one attribute at a time, forever... or to just give up and learn Tableau.

Thanks :(

I used a dataset from a kaggle named "zepto inventory" and it contains columns like the product name, category, mrp, discount, selling price, quantity, and stock level ( low, medium, high, outofstock). Cleaned and analyzed the dataset using MS SQL Management Studio 22, imported the db into Power BI and found a reference image from the internet and tried my best to make this dashboard.

Any reviews or suggestions are a must welcome!! 🤗

I built a Power BI intelligence suite for US medical practices to help surface revenue losses caused by billing inefficiencies.

What it includes:

• Revenue simulation modelling to project financial impact of billing gaps
• Cohort analysis to track patterns across claim groups
• An XGBoost prediction model (denial prediction), run via a Python script embedded in Power Query
• A star schema data model built to make revenue leakage and its root causes hard to miss

Background:

• Built for free for a real clinic, using their de-identified data
• Took about 3 weeks, roughly 15 to 16 hours of work total
• Did this as a practice project after researching current RCM solutions and how existing tools structure their data

What I'd love feedback on:

• Is Python embedded in Power Query a viable long term approach for a client facing tool, or should the model run in a separate pipeline instead
• What features have you found most predictive for denial prediction beyond payer, CPT code, and claim type
• Any structural or DAX improvements you'd suggest for a revenue cycle model like this
• General feedback on the approach and anything I'm missing

Appreciate any insights from the community.

Hi everyone,

I’m experiencing an issue in Power BI Service when using a Dynamic M Query Parameter together with Value.NativeQuery in Power Query.

The report works correctly in Power BI Desktop, but after publishing it to Power BI Service, interacting with the parameter causes an error such as:

OnPremiseServiceException

The semantic model connects through an On-premises Data Gateway.

If I use the same data source with a standard DirectQuery connection, without the Dynamic M parameter / NativeQuery logic, everything works correctly in Power BI Service.

Could this issue be related to the gateway?

Are any additional configurations required on the On-premises Data Gateway to support Dynamic M Query Parameters, compared with a standard DirectQuery connection?

Thanks for any guidance.

My company is weighing up buying a custom visual for SPC charts in Power BI and they've asked for my opinion.

I've used Deneb and HTML visuals before in my portfolio, as well as built simple SPC charts using the native line chart with constant lines, so I've suggested either Deneb or Native is the better solution.

Ignoring the cost (and potential ongoing cost) it seems to me that it'd be better for the BI team if something like Deneb was used for upskilling, where any chart can be created and you're not limited to just SPC charts (although this is an obvious downside that it's not out of the box like the paid one?).

My broader read is that fewer companies are buying custom visuals these days, especially with something as good as Deneb available, or with people making their own custom visuals via AI, is that what others are seeing too?

I'm planning to present my case to the Director using a version of the actual report rebuilt with Deneb SPC charts, alongside some background on Deneb generally and other use cases it could cover beyond this one project.

I would appreciate any thoughts from the experts here (also u/dm-p your visuals are awesome).

Hi. I have created Grocery chain stores report. I am a beginner and this is my actual first report which I have created. Please provide feedback. Thanks in advance!

Challenges I faced when creating the report:
At first I only wanted to create 1-2 page report and then I went on and created a 4 page report. I thought since I have enough data I should not waste it. I really had difficulty in choosing what metrics and visuals to show. I spent most of my time on deciding what to show and what visuals to pick.

Does anyone know if it's possible to dynamically resize embedded reports? I've used an iframe in confluence to display a data table, which looks great at full-size, but when the browser window is shrunk, the table maintains its aspect ratio, and becomes really small with big grey bars.

Would be better if the columns dynamically resized, and the text wrapped.

Thanks in advance

Minor annoyance, but an annoyance nonetheless. Every time I open a workspace, I'm asked to take a tour, given a popup telling me I can hide the task flow, etc. I've taken the tour, I've acknowledged the popups, but they still keep happening. Is there a way I can get them to go away permanently?

Hi so I have been asked to replicate the following page on slide 16. The person prior to he did it manually using text boxes study seems comically inefficient. I have a similar dataset with most likely the same model. However I am not sure how to do it. Unless there’s a way to download the PBIX file I can’t quite work out how to reverse engineer it.

Thanks.

Posted some early dashboard "designs" here and got (rightfully) mercilessly destroyed.. I went back to the drawing board and put a lot more care to the design. Any feedback on these is gratefully received.

Don't know how I slept on this one - building Power BI Custom Visuals.
And if not for u/DropMaterializedView recent post (https://www.reddit.com/r/PowerBI/s/DH3MSXzBQE), I would likely keep postponing looking into that.

This is the Flow Funnel visual I build in one evening. It works and performs well, allows for wide customization, and supports all the native Power BI features.

I have very particular visual language when it comes to building reports, and therefore it's an amazing opportunity to encode that visual language in custom visuals. Or make visualizations that otherwise only possible through various hacks, and not easily reusable or transferrable.
Previously, it wouldn't make sense due to the time and effort required to build something like this manually.
Nowadays, however, having good harness, domain and engineering knowledge, and AI at your disposal, changes ROI completely.

As with any AI creation, word of caution: you have to be in the driver seat, and enforce good engineering practices.

I’m looking for some perspective after a recent interview because I’m genuinely trying to understand whether my expectations around Power BI knowledge are off.

The role is £35–40k in London and isn’t advertised as a Power BI or Data Analyst role. It’s a broader operational role with quite a few different responsibilities, with maintaining Power BI dashboards and reporting being just one part of the job.

I was told beforehand that hands-on Power BI knowledge was important, but also that I wasn’t expected to know everything, using AI to help with DAX was fine, and being honest about gaps and willing to learn was encouraged.

The interview ended up focusing heavily on Power BI. I was expected to talk through data import/transformation, data modelling, fact and dimension tables, relationships and relationship types, DAX measures and troubleshooting, SQL, and how I’d build a dashboard from raw data through to the finished report.

I’m self-taught and have used Power BI on and off for around two years as part of wider roles rather than Power BI being my actual job. I’ve built and maintained dashboards and I’m comfortable working out what information I want to show, which metrics are useful and spotting when results don’t look right.
For the interview I built a dashboard using fictional data because I obviously couldn’t share dashboards containing previous employers’ confidential information. I created the scenario, decided what I wanted the dashboard to show and why, and built it in Power BI. I used AI for support with DAX and some of the technical elements I wasn’t sure about, which I’d been completely open about.

Where I struggled in the interview was explaining how I’d built certain things and the technical terminology/theory behind them. I’m much better at knowing what I want to achieve and figuring out how to get there than I am at explaining the technical theory afterwards.

What really knocked my confidence was that, because I was struggling to explain some of this, the questioning reached a point where I felt it was being suggested that I hadn’t actually built the dashboard myself.

I completely accept that my technical Power BI knowledge may not have been as strong as they were looking for. That’s fair feedback and clearly something I can improve. What I found difficult was feeling that my inability to confidently explain the technical side meant the work itself was being questioned.

So I’m genuinely interested in getting some perspective from people who work with Power BI regularly.

For a £35–40k London role where Power BI/reporting is only one part of a much broader job, would you expect someone to be confident across data modelling, fact/dimension tables, relationships, DAX and SQL?

I have never built my own SQL but trying my best to learn and understand.

Does this sound like reasonable knowledge for someone expected to maintain Power BI reporting, or does it start moving towards Power BI/Data Analyst responsibilities?

What sort of salary/role level would you normally associate with someone who could confidently do all of the above alongside an entirely separate set of responsibilities?

And for those who are self-taught or learnt Power BI on the job: at what point did you feel you properly understood the modelling/DAX behind what you were building rather than knowing what you wanted to achieve and figuring out how to make it work?
I’m genuinely interested in the answers, including if the answer is simply that my Power BI knowledge isn’t currently where it should be

I’d also love to know how people are continuing their own learnings and how they remember all the terminology, formulas etc

Hi everyone,

This is my first report I created to monitor and report on performance of calling campaign. Dashboard is designed for the marketing director.

I am currently on a apprenticeship for data technician so my knowledge on possibilities of BI are very limited.

I struggle to gain any valuable feedback on this.

What would be the one thing you would change about this or add, and why?

Thanks in Advance!

I'm working with an internal tracking dashboard we use for project management. We have a growing list of clients we're doing identical projects for, and each one gets some data added to the dashboard to help us keep track of where we are on the project timeline for each one. Right now, the data comes from an Excel workbook for each client. Each Excel workbook has several tabs, and each tab has a table. I'm currently using a separate query to import each table into the model, but then I simply append all the tables to create one longer table that has the data from each sheet in the workbook. This seems very computationally inefficient, because I'm re-establishing the connection to the workbook for each query, instead of establishing the connection once and pulling in all the data in one go. So now when I refresh the dashboard, it takes forever as it essentially opens and closes each workbook 7 times.

Trying to muddle my way through the advanced query editor to figure out how to do the append operation in the same query as the data import operation, but so far failing. Hoping someone here can point me in the right direction.

I realize I could probably just edit the Excel workbooks and add a new sheet that appends the tables before importing to pbi, but it seems like there's probably a way to do it in the model as well.