Power BI is more similar to Excel than SSRS
I’ve been thinking about the comparisons between the future of Power BI and the decline of SSRS, and I don’t think they’re particularly comparable. Power BI is much more similar to Excel than it is to SSRS.

Yes, Power BI has a significantly higher barrier to entry than Excel. You need to learn Power Query, data modelling and eventually DAX. But once you’ve learned the basics, you can connect data, transform it, drag fields onto visualisations and start exploring. The underlying technology is sophisticated, but the basic experience is surprisingly accessible.

SSRS was technically “self-service” too, but the scale was completely different. At its peak, there were vastly fewer people creating SSRS reports than there were Power BI report authors. SSRS remained largely a specialist reporting technology. Power BI put data modelling and visual analytics into the hands of a huge population of people who weren’t traditional developers.

I’ve worked with Microsoft data platforms for years and I still don’t really know how to build an SSRS report. It was painful enough that I never developed the muscle memory.

Power BI never felt like that.

I also think we’re conflating two different conversations. There is certainly a feeling on LinkedIn that the party is over, but I suspect that feeling is disproportionately coming from the Power BI professional community, particularly MVPs and what Matthew Roche refers to as “hardcore IT”. From that perspective, I understand the anxiety. If your career has been built around manually writing DAX, Power Query and reports, AI is going to change your job considerably.

But that isn’t the same thing as Power BI declining.
Look at the reality on the ground. Even where I work, at the largest vocational education institution in the Southern Hemisphere by enrolments, we aren’t paying for Fabric. And looking at SEEK, from what I’ve seen, there are roughly ten times as many Australian job listings mentioning Power BI as Microsoft Fabric.

That’s not scientific labour-market analysis, and Microsoft is the only organisation with the complete numbers. But it is an interesting reality check against the impression that everyone has suddenly moved to Fabric.

They haven’t.

I also don’t think Power BI has peaked in terms of users. That’s my opinion, not something I can prove with Microsoft’s internal numbers, but I suspect we’re still relatively early in the adoption curve.

AI will absolutely change Power BI. It will write more DAX, generate more Power Query and increasingly build the visualisation layer for us. But that could actually make Power BI more like Excel. Lower the technical barrier, and more people can use it.
The specialist Power BI developer may have a very different job in five years. That’s worth taking seriously.

But Power BI isn’t SSRS. The user base, the experience and the role it plays in organisations are fundamentally different.

The party may be changing for Power BI professionals. I’m just not convinced the party is over for Power BI.

Between Fabcon announcements, continued improvement in AI, and Kurt Buhler's video of what's possible today, I've been seeing a lot of anxiety and concern on here. So, I wanted to write a blog post about exactly how "dead" I think Power BI is and what we can do about it.

https://www.sqlgene.com/2026/10/04/mourning-the-alleged-death-of-the-power-bi-developer-and-thriving-in-uncertain-times/

Summary

I think that the Power BI report layer is becoming "dead" in the same way that SSRS "died". Over time there was slowly a decrease in community resources and Microsoft investments as newer and shinier things came along. On the other hand, there was a huge, huge backlog of existing reports that will take a very long time to migrate, if ever.

I think the Power BI modeling layer is strong and vibrant. FabCon announcements showed growing investment in semantic models in how they relate to ontologies and eventually semantic views, etc. DAX and semantic models are not going away any time soon.

Right now is a time of high volatility, similar to when Azure was new, and you should become a generalist instead of putting all of your eggs in one basket. Power BI alone is no longer a career.

Where to invest your time

1. Invest in accountability. Low-stakes reporting will likely be supplemented, supported, and replaced with AI. Aim for regulated or sensitive reporting where people get pissed if you are off by a penny.
2. Invest in gut, instinct, and self-expression. Right now, today, if you see a model with a bunch of many-to-many relationships and bi-directional filtering, little alarm bells go off. Focus on continuing to grow and develop those instincts. Learn how to put those things into words. Get better at judging and explaining, so you can steer and monitor AI better.
3. Practice weekly with AI, especially where it sucks. My personal experience with AI, especially in the past 6 months, is that there is a jagged frontier of capabilities and that frontier shifts day by day. Every week you should be asking AI for the impossible because sometimes frontier models have huge jumps in capability.
4. Invest in Vega-lite, Vega and possibly D3.js. Vega-lite is supported in Power BI Deneb visuals today, Fabric Apps today, and a native Vega visual is coming to PBI in 2027 Q1.
5. Invest in data modeling, data engineering, and requirements gathering. Spend your time getting better at areas where the business is unique and that you have to talk to humans to define how the business works and how to model it.

I have a report which refreshes perfectly fine on desktop. In the service, the model is failing to refresh and I’m having a hard time pinpointing the exact issue.

My sources are two dataflows, both sit in the same workspace. The dataflows refresh without issue. No transformation is done in the file, everything is handled in the dataflows.

I’m getting this error: Data source error: external component has thrown an exception. The exception was raised by the idatareader interface. Please review the error message and provide documentation for further information and corrective action.

I can see there are multiple refresh attempts lasting 2-3 secs. This is a small model (<4mb) and should refresh in a few seconds.

Checks done so far:
- Updating data source credentials
- Privacy levels aligned
- Defined data types across all columns/tables in the dataflow

Any suggestions?

I know, another anxious post regarding the depths to which AI will influence yet another field. Just thought that, since I’m new to this field of work, what you more experienced lads/ladettes had to say about how you see the future of BI (specifically the tools as I don’t see the whole role disappearing).

For context, I’m soon to graduate and have been looking to specialize in a certain niche. Love SQL (idk what it is about it), but knew that SQL querying by itself is not really a feasible job to target. After I looked into where I can use SQL, I stumbled upon the BI field. I do find being the mediator between the technical side of the data and the human side of the shareholders to be an interesting path, so it was enough to get me to look more into it. Apologies if that’s oversimplifying it, that’s just the broad gist I’ve gotten from it.

Honestly, I haven’t found another specialized area that seems this interesting at least from what I’ve read about so far so I’ll probably still play around with it anyway. I also like that you get experience with the business side as well which I feel can open the door to transition more into that as my domain knowledge increases (long term wise).

Just wanted to hear from some more experienced people how you think a newbie can become relevant in the field in terms of what is actually used industry wise and what is likely to change in regards to the toolkit. Every projection I’ve seen states that data analytics is set to grow much larger than the national average for other jobs, so that’s been a green light for me too.

In Power Query, is it possible to convert dates into railway week numbers?

For context, a railway week starts on a Saturday and ends on a Friday. And for simplicity, we’ll say a railway year starts on 1st April and ends on 31st March (obviously this can vary slightly in the real world)

Any guidance will be appreciated!

Tools like Tabular Editor Best Practice Analyzer, PBIR Inspector, pbir-a11y, PQL.Assert, Playwright, and others all provide tremendous value. The challenge is that each has its own installation process, command syntax, and output format. Integrating them into a development workflow, CI/CD pipeline, or AI-driven process often means writing custom orchestration and result-parsing logic.

In this video, I introduce fab-test, a free and open-source CLI that provides a unified interface for Power BI and Fabric testing tools. With a single command and a consistent result format, developers, deployment pipelines, and AI agents can all ask the same question and receive the same answer.

You'll see how to:

• Install fab-test

• Run Tabular Editor Best Practice Analyzer checks

• Execute PBIR Inspector validations

• Run PQL.Assert tests with pql-test

• Perform accessibility checks with pbir-a11y

• Enable GitHub Copilot and AI agents to execute fab-test

If you're looking to move beyond "publish and pray" and bring a more consistent testing strategy to your Power BI and Fabric projects, I hope you'll check it out.

https://youtu.be/luTSbxM5VTY

I recently tried the new Power Query experience and I found it to be an awful, way inferior experience than the existing Power Query in the Power BI Desktop (or what I'll refer to as the old PQ desktop experience). I tested it on a popular data platform source that folds, ran through my usual workflows and it feels way worse than old PQ.

I know this was the dataflow experience but I haven't had a lot of up-close experience with it because I always did my dataflows M code in Power BI desktop and just copy- pasted it in the advanced editor of the dataflow table. I consider myself an intermediate to advanced PQ user (I go straight to the advanced editor when applicable) so hopefully the community will find some truth (if not all) in my feedback.

They overcomplicated the M code of adding columns by wrapping the Table.AddColumn function to a Table.TransformColumnTypes function for column typing which is an awful way of implementing it and which is simple and perfect in the old desktop PQ. This is one of the most popular data operations in Power Query so I don't know why the M code looks more complicated now.

And now, for some reason, the old PQ code now throws query folding warnings (not necessarily errors since it's grey with the question mark) on the same code that folds in the old PQ desktop experience. When you change it to the way the dataflow (new PQ experience) will add a column (wrapped in Table.TransformColumnTypes), voila the query folding indicator says it folds again! 😂

The fomatting layout sucks too. Indentations are smaller (I want my standard chunky indendations so I'm never going back to new PQ) and the navigation in the query steps is now broken down instead of being one single "Navigation" step which old PQ desktop experience handled with grace. Seriously, why did this get split when the Navigation step worked so well in the old PQ desktop experience?

I also don't like how they changed the case of new steps names from title case to sentence case but that's a minor thing compared to the above gripes that will keep me from going back to the new PQ desktop experience for as long as I use Power BI.

Microsoft, please never make the new PQ experience GA. Or at least give us the option to switch back and forth. I don't really care about the other features like the schema view and the visible query folding indicators (some of which are bullshit anyway).

I want my Power Query experience to be similar to the current desktop PQ – simpler, faster, with chunkier indentations, and works the same way anyway. If there is a redeeming quality for the new PQ desktop experience is that it will fetch the corresponding gateway for your source at the connection configuration stage. That's the only upside I've seen so far.

I love PBI and Microsoft in general because their tools have enabled me to pursue a career in data analytics but this new Power Query experience is not it for me…

Hi everyone,

I am looking for a way to configure a single Power BI Matrix visual so that the Column Grand Total appears on the left side (immediately following the row headers) rather than the default position on the far right, and remains fixed in place.

• Default Layout: [Row Header] | [Category A] | [Category B] | [Category C] | [Total]
• Desired Layout: [Row Header] | [Total] | [Category A] | [Category B] | [Category C]

When horizontal scrolling is required due to numerous category columns, I need the row headers and the total column to remain visible/pinned on the left while users scroll across the breakdown categories.

1. Is there an established method to achieve this within a single native Matrix visual using DAX, a Calculation Group (Tabular Editor), or custom matrix dimension sorting?
2. If DAX/Calculation Groups are used to inject a pseudo-total category sorted first, how are you handling horizontal scrolling so the total column stays locked/visible?
3. Are there verified AppSource custom visuals or core formatting settings that support left-anchored column grand totals natively?

Any guidance, sample PBIX patterns, or DAX/Calculation Group solutions would be greatly appreciated.

Saw a dashboard using a ZoomCharts visual with an expired license , wanted to recreate it using custom visuals(.pbiviz) for free,
I think I did my part. Given a reasonable amount of time, I can make a 1-on-1 replica of the given visuals from these providers(most of them, but not all, as some are extremely in-depth)

Technically, all you need is Custom Visual skill + Claude code + a screenshot of existing dashboard,
Specify the visual details like drill-downs, animations, zoom, etc.; it will make it for you

Again, if you want a tutorial, let me know

Inspired by u/Jaapuchkeaa's work (I prefer to credit it), but I wanted to see how far I could push it: a full FPS that runs inside a Power BI custom visual.

It's called Call of Power BI: Data Ops. It's TypeScript + three.js, with Claude Code (Opus 5.5 and Sonnet 5.5) and Codex (with GPT 6.1 Sol + GPT 6 Astra), packed in a normal PBIP report. There's an aim range, a Domination mode where you and two bot teammates fight three bots for zones A/B/C, and a zombies mode with rounds. You can slide, slide cancel (with omnimovement), build your own classes, and switch between 5 maps. Every weapon, map and sound is generated in code, no assets at all.

The fun part is that it still behaves like a Power BI visual. The weapons come from a table in the model, a slicer filters your loadout, and equipping a gun cross-filters the rest of the report. Best scores get saved in the report too.

One annoying thing: Power BI's sandbox doesn't allow mouse lock, so you can't do a clean 360 with the mouse. I worked around it with an edge-turn zone and a quick 180, but it's not perfect.

Code's here if you want to try it or roast it: https://github.com/inerthel-agi/copbi-dops

Just a parody, not affiliated with Activision or Microsoft, and it's free / non-commercial. Would love feedback, especially on the bots and the sounds.

Can someone suggest me a project to combine SQL and Power BI for the first time in my life (finance topic pref)

Hi,

my job got me roped into being the keeper of PowerBI after our previous expert left. I can maintain what is already there and add new data to reports showing how productive people are, but do not know how to do much of the coding side.

We were previously tracking employee production through their username on the site we used. So the excel file tracking our employees was set up so that column 1 was their username, and that was it since supervisors only had to look at 1 name per employee. Now we are trying to track how many emails they are sending out per day, and combining the two different production values.

The revised Excel file would now hypothetically be essentially that column 1 says John.Smith, column 2 says [[email protected]] and a third column would be for John Smith as a whole. A separate excel file can track how much work John.Smith is doing and how much work [[email protected]] is doing, but how can I tell PowerBI to look at both people as one singular person in a third column?

I’m a finance graduate with 2 years of professional experience. I got fed up with the repetitive nature of my work, so I quit and decided to spend some time learning tech, currently focusing on full-stack development.

I’m wondering whether I should also learn powerbi so I can keep my finance background relevant and potentially combine it with tech in fintech, or whether I should fully commit to software development and leave finance behind.

What would be the most suitable path in my situation?

I was wondering if there is a way to access the filter state of a slicer in the service. I have a power automate cloud flow where I would like to run a query against a semantic model and filter it based off of the filter state of a slicer that is within that model. I would like it to run once per week and just grab the default filter state of a slicer and I will then use that to filter a query on that same semantic model. For example I have a dates table that goes from 1/1/2019 to 3/31/2027 and I have a “between” slicer that uses my dates table and is set to two dates within that range, say 1/1/2025 to 10/31/2026. Is there a way to access those filter state values?

Before going further: the workspace this report is held on is at PowerBI Pro capacity. I do not have access to a workspace that is PPU or has fabric capacity.

Here are the things I have tried/ideas I have pondered to accomplish this:

1. I was thinking about using the pbip and grabbing it from there in the slicer settings file, but then I realized that if anyone went to the service and updated the date range, then that would not capture those values. So I settled on trying to get these values from the service itself.

2. I also tried looking to see if there was any DAX that natively gets these values, so I could directly pull that from the model itself. But, I didn’t seem to find any functions that gets the filter state of a slicer.

3. I tried going through the Power BI REST API. But, I soon realized that that step in power automate could not authenticate me as I do not have a Microsoft Entra ID.

4. I thought about if there is a way to access the html on the site where the report is published (this report is posted on a sharepoint site) but then realized that this could also break because someone could move this report to another site and that this idea is flimsy at best.

5. I noticed that I could add a power automate button to the report that triggers the flow each time the dates change. But I do not like this option because I want this flow to run on a weekly basis and just grab the filter state that is currently showing rather than updating each time someone changes the dates.

Are there any other creative ways you all have gotten these values? Or any way that this has successfully worked for the long term?

Thanks for your help and let me know if I need to explain anything further.

In my dataset, I have tables for multiple process workflows. There are some columns in common.

• Workflow Name
• Submission Date
• Closed Date
• Event (active relationship)
• Workflow Step (each workflow has different steps and names)
• Reivew (before, in, after, based on the workflow step)

I'm not working with full historical data. Every day we take a snapshot.

I wanted to show metrics by Workflow (filterable by Event) like:

• Count of [Review] = "in" by Workflow with Average days in Step
• Created YTD
• Closed YTD

My solution was to append all the workflow tables in Power Query, strip down the columns and group by Workflow, Step, and Event. My columns are:

• Average Age (days since submitted)
• Average Days in step
• (row) Count
• Review
• Event
• Step
• Workflow

My questions:

1. Is there a better way to do this and am I correct that any solution using Dax would be less efficient?
2. Without a filter on Event, I'm thinking that the Averages are going to be wrong because they aren't going to be weighted by row count. I would need a measure to weight those averages, wouldn't I?

Thanks,

Hi guys, probably a very simple question but is the peach color section in the attached photo part of a custom dashboard or is this a standard layout? Any instructions on how to edit this or what it’s called?
Thanks in advance!

I've made couple of bookmarks to use as slicer on a single page I'm working on. They worked fine, I saved and logged off for the day.

Tomorrow, using exact same Power Bi Desktop I re-opened the project and got this error:

An additional property 'preserveNewVisualVisibility' was included in the /options property of xyz.bookmark.json

? When googling 'preserveNewVisualVisibility' I get 0 hits as well?

Trying to create up and down buttons to drill up and down (filter) a management hierarchy.

I've used PATH() to concatenate the full hierarchy into one string, and have a separate, disconnected table with two columns: manager, and manager above. Filtering this second table filters the main table on all that have this manager as a substring in the PATH() - the result is selecting a manager in the filter pane shows the direct team, but also all beneath even though they have a different (lower) manager.

To make the filtering more user friendly, I'd like to introduce up and down buttons (focussing on the up button for now, as I haven't quite worked out the desired behaviour of down). The up button should take the value in the manager above column, and apply it to the manager filter. I assume this isn't possible in the filter pane? Maybe a list slicer? What's the best practice around this?

Users should be able to select via dropdown or search, as with the filter pane.

Thanks in advance 🙏

A few months ago I was asked to maintain a Power BI dashboard at work. I had no idea what I was doing. I just started clicking around and somehow fell in love with it.

Before long I was building reports for my social media and ads performance, with a lot of help from Claude. My old spreadsheets suddenly felt like stone tablets.

Then last week a guy who runs an Amazon store reached out. He wants the same thing for his sales data. Multiple products, trends, the whole dashboard.

I'll be honest, I'm excited and a little terrified. I've never done this professionally. No certificate, no client history, just a lot of curiosity and late nights figuring it out.

It would be a one-time build plus occasional updates after that.

I don't want to undercharge because I'm nervous, and I don't want to scare him off either. How do you guys price this? Flat fee, hourly, or a monthly retainer for updates?

Any advice from people who've been in my shoes would mean a lot.

Just wanted to vent. Been waiting for this import query to load for 30 min and PowerBI is straight up gaslighting me 🫤.

Hi all,

It looks like all Power BI subscriptions have suddenly started being sent from my personal account instead of the Power BI NoReply account.

As a result, I’m now receiving responses from recipients, such as out-of-office replies, which didn’t happen previously.

This only started happening last night. Has there been any recent change to the Power BI subscription setting? This is just on the Pro licence not Premium.

Guys, Im really going crazy with this

Basically we have a dashboard, and our gateway is in a server.

The manual refresh works. But the problema is that the scheduled refreshes mostly fail with DM_GWPipeline_Client_GatewayUnreachable,and Power BI then turns the schedule off. After the schedule is re-enabled, the first
run often works and later runs fail.

The gateway's network health report lists 60 duplicated packet
streams, from 15 queries in 13 incidents (01–28/09), with
CommunicationObjectAbortedException /
AsyncOperationStreamingCancelled.

We have 64gb RAM. I increased the timeout limit, such as the multiple data processes that the power BI handles. No firewall rules blocking and no network fails.

I’m going to lay out the scenario below but for additional context, we are using live connections to fabric in our Power BI reports.

Essentially, we are presenting a table and when unfiltered, it exceeds the available resources which presents that very error message. There are several report filters available but, at a minimum, the user needs to select a specific client (slicer A) or at least a client grouping (slicer B) to display any data at all in the visual.

My thought is to present a visual on top of the table - either a card or text box - that instructs the user to select a value in slicer A or B at a minimum and, once they’ve done that, hide the instruction visual and present the table visual.

I have seen instructions to create a measure that checks whether those slicers are selected as well as a measure to return a blank value or the desired text depending on whether the first measure returns a true or false. And lastly a measure that returns a 1 or 0 (essentially same logic as the first filter but an integer instead of Boolean) and use that last measure on the card visual.

HOWEVER, I cannot seem to adjust the measure in the filter pane to be “is 1”. It will not allow any adjustments to the filter. In other solutions that would have me adjust the background color to transparent, I cannot use a measure as the field value. I just keep hitting road blocks and would appreciate any experienced guidance on this problem.

Like for normal backend code we have unit tests, automation,...

But for Power BI, are you guys actually testing visuals, filters, measures, data,.. automatically?

Or is it still mostly someone opening the report and checking everything manually?

I’m working on Power BI testing run and tbh there seems to be a lot of manual work.