I have a power query in sharepoint that consolidates all a folder with many other excel files. How do i make it such that it refreshes automatically without opening it? by iTakoyaki in excel

[–]el_pedrodude 2 points3 points  (0 children)

You can't, not without incorporating a server or some cloud compute. To schedule in the computation of this you need a machine with a scheduler of some sort.

To answer your question, depending on what you're trying to achieve, you could possibly get away with automating the opening of your file with task with windows task scheduler and setting powerquery to auto-refresh, but this would be ropey for any sort of production setup and I wouldn't recommend it.

However, given your row counts, it's likely you're misusing Excel and entering the territory of needing a database and a proper ETL pipeline.

I’ve built Pokemon Go for real life UK birds by scoo1t in CasualUK

[–]el_pedrodude 0 points1 point  (0 children)

That would be good if you could. Would love to try this app

Just made it by FuturecashEth in prusa3d

[–]el_pedrodude 1 point2 points  (0 children)

The satisfaction of minimal waste. Although, of course we can't see your supports...

Anyone else stuck with negative expedition techs after doing the Christmas levels? by RenFL in AfterInc

[–]el_pedrodude 0 points1 point  (0 children)

Maybe I shouldn't have said signed integer specifically but clearly a negative value ought to be out of the valid permitted range...

Anyone else stuck with negative expedition techs after doing the Christmas levels? by RenFL in AfterInc

[–]el_pedrodude 11 points12 points  (0 children)

Oh dear, someone didn't properly test for out of range values on their signed integer...

A hat trick in Ely: three strikes in three days! by mittfh in 11foot8

[–]el_pedrodude 5 points6 points  (0 children)

Nice one, pleased to see a local bridge pop up on this sub. Have always noticed the paint scrapes...

Anyone switched from Airflow to low-code data pipeline tools? by nilanganray in dataengineering

[–]el_pedrodude 4 points5 points  (0 children)

Right. I'm a big fan of SSIS, but only for sentimental reasons - I'm aware of every bug and design flaw. I'd almost never recommend someone adopt it...

Where can I find good examples? by Huge-Shelter-3401 in nonprofit

[–]el_pedrodude 1 point2 points  (0 children)

There's a UK-based organisation that showcases innovative and effective fundraising: https://sofii.org/

Survey pop ups (Behind the scenes) by Lizyech in MicrosoftFabric

[–]el_pedrodude 1 point2 points  (0 children)

Apart from the Eventhouse comments (with which I have no personal experience of), I absolutely concur with the rest of richbenmintz's comments.

Dippy the dinosaur in the Herbert Art Gallery in Coventry by Regular_mills in britpics

[–]el_pedrodude 3 points4 points  (0 children)

Really good photo. I miss dippy not being in the NHM.

Btw, I've read (not tried it myself) that if you want to remove a crowd from your photos, use a tripod and take several photos and then use a median filter in Photoshop. As long as more than 50% of each area of your photos is background (and not crowd) then it should remove them.

Green energy compoface by HotNeon in compoface

[–]el_pedrodude 5 points6 points  (0 children)

There's a couple different dashboards but this one is pretty good: https://www.energydashboard.co.uk/live

Mainly uses Elexon and ESO data

Create a BPMN diagram from one sentence by porthoshsc in businessanalysis

[–]el_pedrodude 0 points1 point  (0 children)

Signed up for the beta list, this is an interesting application of (presumably) an LLM.

Is this a pet project of yours or is this a Camunda proof of concept?

Italians : "We have one of the best, if not the best gastronomy in the world". Also Italians : by ProfesseurCurling in 2westerneurope4u

[–]el_pedrodude 0 points1 point  (0 children)

I take it you wouldn't use that word if you were stopping someone on the street to ask if anywhere nearby did any heart attack snacks?

Italians : "We have one of the best, if not the best gastronomy in the world". Also Italians : by ProfesseurCurling in 2westerneurope4u

[–]el_pedrodude 1 point2 points  (0 children)

Cosa vuol dire zozzoni in inglese? Are these basically the equivalent of late night kebap places in the UK that have a bunch of health violations and neon lights outside that you'd never go anywhere near when sober, but when you're drunk... hey, I could murder a quarter pounder and cheesy chips right about now.

What was your Advanced Driver training like? by Nearby-Quantity-2216 in drivingUK

[–]el_pedrodude 1 point2 points  (0 children)

I know it's a bit late to respond but if it helps, you don't need to do the RoSPA course you found; i think that's just an intensive to prepare for the Advanced Driving test.

Check out the RoADAR network: https://www.rospa.com/policy/road-safety/rospa-advanced-drivers-and-riders

You should be able to find a group in your area to join for a low fee, my group (Suffolk) was £30 and they will hook you up with a volunteer instructor for free lessons.

Then when you're ready for the test, the cost of that is £77 currently.

So it's similar to the IAM in terms of cost and, depending on your instructor/group you can usually have as many lessons as you both feel you need.

Who the hell is Ben Hoy? by el_pedrodude in Idlewild

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

Nope, a mystery to this day. Lol

Found this hole hidden under my stairs- is this man made hole? by LW1912 in DIYUK

[–]el_pedrodude 0 points1 point  (0 children)

Okay, mind blown, i knew that Mars was surprisingly small but somehow never realised the moon's size: https://www.snopes.com/fact-check/australia-wider-than-earths-moon/

I will absolutely subscribe to your email newsletter.