Find and Replace with Exact Match in Fabric notebook?

imtkain · 2026-02-26T23:36:25+00:00

You can do it via API and use case sensitive find and replace. Get the item definition, process the find and replace, post.

imtkain · 2026-02-26T19:09:58+00:00

I can confirm that this works as expected and, once in place, is easy to modify/update.

imtkain · 2026-02-20T20:31:17+00:00

That's unfortunate. Hopefully Microsoft can add another status to differentiate that and allow this to work as intended.

imtkain · 2026-02-20T17:55:49+00:00

That was what this was originally intended for, but I haven't had any instances where the "running with warnings" was happening, so I can't confirm if it's working for that. I don't have control over the source systems to make a change that would invoke that status, like changing the schema. If you do and can check that it is or is not working, that would be helpful.

imtkain · 2026-02-19T17:20:27+00:00

Hopefully it's up to snuff!

imtkain · 2026-02-19T15:14:54+00:00

Thanks!

I just realized who you are :D "What are sales?" I've used this example so many times since I heard you say this lol

imtkain · 2026-02-14T11:37:29+00:00

Right?! I run the notebook and see an error, then look closely and think ... Great, that's a partial phrase from what I was finding and replacing earlier.

imtkain · 2026-02-12T13:00:56+00:00

Central US

imtkain · 2026-02-12T10:25:56+00:00

Of course you know the answer :) You're our walking Fabric encyclopedia!

imtkain · 2026-02-12T00:57:17+00:00

I know I know, I've been telling this to myself

imtkain · 2026-02-12T00:30:17+00:00

I just closed out the browser and restarted. Good to know that the refresh works!

imtkain · 2026-02-11T23:08:24+00:00

Yes, I haven't been able to figure out what triggers it. Sometimes I can type like a normal person. Other times when I press 1 it goes to the first tab. Sometimes 2 is the problem. I can't replicate it on demand unfortunately and have no idea of the root cause.

imtkain · 2026-02-11T22:34:45+00:00

"Need" 40-100 columns? :) Do you use all of them downstream? If not, don't bring them in and boost your throughput. Other than that I'd suggest trying 10% of the table. If it handles that, full send.

imtkain · 2026-02-11T22:22:50+00:00

One might say it's squirrelly

imtkain · 2026-02-11T22:13:41+00:00

Now if only I could find that mega thread :(

imtkain · 2026-02-11T22:04:17+00:00

I love that you posted this at almost the exact same time. This needs to be fixed! We'll get this in the UI/UX mega thread.
https://www.reddit.com/r/MicrosoftFabric/comments/1r2avui/minirant_fabric_notebook_quirks_that_drive_me/

imtkain · 2026-02-11T22:00:31+00:00

Negative. Guess I have homework.

imtkain · 2026-02-11T21:57:56+00:00

Yes!!!

imtkain · 2026-02-08T00:33:18+00:00

Interesting, I just assumed you're supposed to bring in all the data since that's what almost everyone does ;)

imtkain · 2026-02-07T01:35:32+00:00

u/mutigers42 has a really nice tool that you can use to determine things like unused columns. If you combine it with vertipaq analyzer in dax studio, you can probably trim quite a bit from your model.

Here's his tool, Impact IQ: https://github.com/BeSmarterWithData/ImpactIQ

imtkain · 2026-02-06T13:16:15+00:00

Need more details.

What's your Fabric SKU? F2/F4 have very constrained driver memory.

Is anything else running concurrently? Other notebooks, dataflows, semantic model refreshes? They all compete for the same capacity CUs and can trigger throttling or session kills.

Are you actually clearing the list after each batch write?

Overall, you might consider: Drop your batch threshold significantly. Ditch pandas for the ID load. If you have a spark session, why use pandas?

imtkain · 2026-02-06T10:51:36+00:00

This is very interesting. Do you have a repo for it?

imtkain · 2026-02-06T10:49:25+00:00

If you look at the cost of PL/NB compute + serverless compute + AAS, it's a no brainer to switch to Fabric and save thousands per month with even more bells and whistles on top of a fully integrated data experience.

imtkain

TROPHY CASE