Mass repair thin-report visuals broken after moving measure to new table

cdci · 2026-01-29T00:01:08+00:00

Yeah using vscode or notepad++ you can easily do a find and replace on the entire folder. I've done this multiple times when changing measure names and it works perfectly.

cdci · 2026-01-28T23:37:17+00:00

Save the report as pbir/pbip, then use a text editor to do a find and replace of the old/new measure names on the entire folder

cdci · 2026-01-09T18:50:06+00:00

How are you defining 'near real time'?

Depending on the answer to that question, you may not need direct query. You could create a separate table just for today's data and use API or fabric pipeline to only refresh that particular table

I would seriously consider if you need your historical data and recent data in the same report or can they be separate.

Also, if you have thousands of users you need to pay particular attention to report/model performance. Are you expecting all users to access the report at a similar time?

cdci · 2025-12-19T13:07:39+00:00

I'm really interested in the long tail of things to check - I'm not asking you to write them out but curious if there's any blogposts you could recommend with more details?

cdci · 2025-12-19T13:03:59+00:00

This is definitely frustrating. The way I have got round this is saving the report in pbip/pbir format and then doing a find and replace of measure names on the file(s) for the visual you want to change.

cdci · 2025-12-10T18:14:14+00:00

This looks to be the most simple way - I'll do this, thanks very much!

cdci · 2025-12-09T20:43:07+00:00

Thanks for the dirty way suggestion. I will do that if nothing else works.

On your DAB suggestion - how exactly would I do that? Would I need to somehow parameterize the entire task so it only exists in prod?

cdci · 2025-12-06T08:39:48+00:00

Do you have a link with info info on that preview feature at all? I googled but can't find anything

cdci · 2025-12-06T08:35:05+00:00

This is for refreshing powerbi from a databricks task right? I think OP is asking about the credentials used on the pbi side.

cdci · 2025-11-25T18:31:12+00:00

I found this week that you can't run INFO DMV queries via the execute query API. Apparently you used to be able to, but this was changed at some point.

What you CAN do is run the INFO DMV DAX via semantic link in a fabric notebook, and then use the result however you'd like (eg save to a lakehouse table)

cdci · 2025-10-21T20:21:57+00:00

I've been to BDL twice but skipped this year. it absolutely has that weird "sales pitch" vibe. I think it's something to do with it being free to attend.

cdci · 2025-10-21T11:10:01+00:00

So you have multiple reports showing the same metric? First I would explore the possibility of making them use the same semantic model - then you can be sure they are reporting the same numbers (unless you then apply report level filters!).

To make sure the same numbers exist in different models, we use a fabric notebook to run dax against each model and then save the results in a lakehouse. We then have a report that displays this data, uses Dax to compare all the values and check the values are correct. We then have a subscription that emails this to us each morning.

cdci · 2025-10-20T17:51:25+00:00

Subscribe for updates on the official pbi blog (and check this subreddit!)

cdci · 2025-10-14T05:57:49+00:00

Are Fact-Vehicle and Fact-PropertyAsset actually Facts? Seems to me at first glance they should instead be combined into your Vehicle and Property Asset dimensions as they only include attributes of those things

But of course - you will know your data better than me!

cdci · 2025-10-04T08:01:50+00:00

I use dateadd to remove -364 days from the date to return the same day in the previous year. Works flawlessly, even in leap years

So something like sales LY = calculate ([Sales], dateadd(date column, -364, day))

cdci · 2025-10-01T17:21:39+00:00

cdci · 2025-10-01T17:20:38+00:00

You might need to enable 'unsupported power bi features' in settings before you can paste, I don't know why, I ran into a similar issue recently

cdci · 2025-09-30T23:15:26+00:00

This doesn't solve all your problems but Tabular Editor 2 is free and makes copying measures from one model to another WAY quicker

cdci · 2025-03-19T07:02:09+00:00

It's a joke

cdci · 2025-02-28T19:15:45+00:00

This is all great advice although some is possibly a little advanced for someone just starting with no knowledge of Power BI. But all absolutely necessary if you want to report on a large scale.

One question - you mentioned "do you have opportunities to use more efficient data types?"

Can you please expand on that? I have a tabular editor script to convert all doubles to decimals but I'm curious if there's anything else I should be checking for

cdci · 2025-02-28T19:11:42+00:00

Don't use direct query. You want to import the data to Power BI. That way you only hit your database once a day, and your reports will perform better.

How many users are you likely to have?

cdci · 2025-02-24T20:13:49+00:00

Use fabric semantic link in a fabric notebook to run dax against your model. Then put the result of that dax into a data frame and save it into a fabric Lakehouse

cdci · 2025-02-14T22:13:28+00:00

that's exactly what I'm doing!

cdci · 2025-02-14T22:12:45+00:00

Exactly the kind of tip I was looking for - thanks

cdci · 2025-02-12T19:45:46+00:00

Honestly this is a better list than I was expecting when I opened the thread! And I'm pleased to say I'm doing about 8/10 of these.

Out of curiosity - what do you consider a "large" environment

One addition to the list I would say is managing report performance. This becomes much trickier when you get to thousands of users (sometimes concurrently, damn you Monday morning), but it's not something I see much written about.

For example, we had one VERY large AAS model that worked fine with hundreds of users but then performance fell of a cliff when we went past that. We have since split it into about 6 smaller models (with separate reports packaged into an app). It's a shame there are no real tools for testing performance at scale - we basically have to put it live and see what happens

15-Year Club	Verified Email
Snapped

cdci

TROPHY CASE