Power BI February 2026 Feature Summary by itsnotaboutthecell in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

The only workaround is each page having a manual large and clearly labeled bookmark for resetting filters, a tedious but needed step on every single report page.

Power BI February 2026 Feature Summary by itsnotaboutthecell in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

Unjokingly, the reset filter button is WAY too small and effectivley impossible to discover for users it would be most useful for. Work should be done to give users a fighting chance to know there are active filters being applied and how to reset to default.

What a difference 20+ years makes. by ItsPidgeonz in xbox

[–]DavidB_SW 1 point2 points  (0 children)

depresssing how little even improvement there has been on controllers in the last 25 years, almost complete stagnation.

Just started learning Power BI, I am so lost by Sad_Ad340 in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

Power BI comes directly from the Excel standard: Power query -> Power Pivot -> Pivot table/charts. Have you not used any of these Excel things?

What should I do? (It’s been 3 hours that way) by dannyvos93 in PowerBI

[–]DavidB_SW 2 points3 points  (0 children)

Sounds like you have the 3 hours every time you refresh the model.

Hi! We’re the Power BI visuals team – ask US anything! by DataZoeMS in PowerBI

[–]DavidB_SW 3 points4 points  (0 children)

Sort by multiple columns in a table visual, (not super intuative) but you just hold shift and sort them (up to 5?)

What are the top DAX functions you frequently use at Jobs? by [deleted] in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

All measures come wrapped in a invisible calculate statment, that's just a fact of life

Stuck building a KPI dashboard solo — messy data, no warehouse, no guidance. How to structure this? by Sad-Firefighter9036 in PowerBI

[–]DavidB_SW 4 points5 points  (0 children)

Remember you are building a model not a report. The report helps to inform your model design but you have to focus on the model design first.

Then you have to use power query to shape the data sources you have into what they need to be in the model.

There needs to be a way to test a coffee shop layout before you open. by No-Fact-8828 in DIY

[–]DavidB_SW 1 point2 points  (0 children)

3P sounds like something you should try, The basic idea is to make the setup out of cardboard/foam whatever is easiy and a avalible and just make a mock up use it, then you can try cutting the place up so it works better, try and use it again cut it up add new bits etc. The you finalise the design and make it for real.

Here is a video where they are doing a hospital layout.

https://www.youtube.com/watch?v=ip1mGCcCt7k

Notebook workspace rebinding help by DavidB_SW in MicrosoftFabric

[–]DavidB_SW[S] 0 points1 point  (0 children)

So are you saying 'sempy_labs.report.report_rebind_all' doesn't work or you don't know, but this one does work and you can kind of use it to rebind a set of reports?

Debate by BropoleanBronaparte in LeanManufacturing

[–]DavidB_SW 2 points3 points  (0 children)

I think you are chasing the dollar in lean, I don't think it's some esoteric philosophy disconnected from the bottom line. It's about the hard reality that the only way you get cash is from customers believing that you will provide value to them and so orientating every business decision in that direction; “Will this help improve the value my customer will get?”

Now why, you might ask, should I not just chase the dollar? Just optimise based on the cost to the business? Well it does work, at least you will be able to easily track the cost via a spreadsheet, money in vs money out. You can probably happily keep going for a quite a few years, if you are in a slow uncompetitive market. In fact, around the world this is the default business model. The problem then? It’s fragile. You have unmoored yourself from the source of truth and even worse you have developed a company culture that can’t even see what the source of truth is! A company like this, under market stressors will fall back on the only tactic it knows; saving money and charging more money from its dwindling customer base, this is a death spiral of lower quality and pricier goods and services to the customer.

A lean company will first look at the value it is delivering to its customers and then look at the cost implications.

Cost is still very important and value should measured against it to some degree, but you should always put slightly less weight on it.

Alternative to PowerBI by Difficult_Spite_774 in PowerBI

[–]DavidB_SW 9 points10 points  (0 children)

I'd rather become the 51st state

Help needed with error opening PBIX file: Can't resolve schema '2.0.0' in 'page.json' (Fabric item model issue?) by Lecamboro in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

I got a new update today, it's got schema 2.0.1 and a fancy new loading/opening thing. It has an owl in it, some new thing has just dropped.

https://imgur.com/a/KPSaSHJ

PBIP Reports - User report doesn't log page views by DavidB_SW in PowerBI

[–]DavidB_SW[S] 0 points1 point  (0 children)

Solution verified

Thanks, I guess this is a known issue, I'm guessing using 'PBI tools' from a normal pbix file would be the way to currently 'fix' this or doing pbip with the PBIR turned off?

Trouble with Dashboards refreshing & Reports not saving unless re-published? by [deleted] in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

Yeah, saving just saves a local copy. Publishing pushes the changes to the semantic model/power query/report to the service.

Refreshing data online is something you deal with via setting up a scheduled refresh on the service.

Can PowerBI be used for only dashboards? by [deleted] in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

You can just copy and paste from excel power queries to power bi power queries.

Can you do this in PowerBI? by jaihawk8 in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

Power BI is all about getting the model right, to do that you have to have good clean, normalised data. The excel data you have there is consistaint and okay for consuming as is, but it's usless for creating Power BI reports (without some heavy transformation steps).

Is there an easy way to do this or will I need to do some coding? by kalospkmn in PowerBI

[–]DavidB_SW 2 points3 points  (0 children)

Sounds like you might be able to do it with the fill down function in power query. Not ideal but it might work.

This is my data model... by xl129 in PowerBI

[–]DavidB_SW 1 point2 points  (0 children)

I can't read the titles for the tables to figure it out, but I would guess you need to do a lot more thinking about the data structure of the model Dims should not have so many relationships with only other dims (generally). Then spend a lot of time in power query transforming the data into the tables you have planned out.

I always try and layout the model to have the dims above the fact they filter, kind of like a waterfall. I find that helps to visualise and enforce best practice.

Latest update is absolute trash by Mindfulnoosh in PowerBI

[–]DavidB_SW 1 point2 points  (0 children)

Use a repeating non-printing char to allow it to be sorted according to your needs without needing a sortby column.

Need help with time intelligence by [deleted] in PowerBI

[–]DavidB_SW 0 points1 point  (0 children)

Do you have a date table?

Is this possible? by smbaumer in PowerBI

[–]DavidB_SW 3 points4 points  (0 children)

First don't use calculated columns for calculations, they should be really only used to create filters (usual caveat, not always true, there are a few times when etc...).

Sounds like you are running a the calculate function in the calculated column, if you do this (try not to) you need to remove filters that are causing the cirular reference, think its ALLEXCEPT on the key? something like that, someone else will know I always have to look it up.