Jordan's Avatar

Jordan

@excelmiddleware.bsky.social

Shadow IT specialist

27 Followers  |  81 Following  |  76 Posts  |  Joined: 14.11.2024  |  2.4056

Latest posts by excelmiddleware.bsky.social on Bluesky

Lum... I'm gonna lum...lumming your bum is what I do

07.08.2025 22:02 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Perfect birthday gift for my daughter named Penny

07.07.2025 18:21 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Most of those fear of listeria diet restrictions are dubious anyway

21.06.2025 19:59 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Be careful here, exporting paginated reports to PDF is a relatively expensive operation to perform from a CU standpoint. 1000s of exports will drive up background consumption very quickly

05.06.2025 17:28 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Barely anybody ever made time to prep data models appropriately for *human* consumption, but per my senior leaders we have to spend time improving model quality because the computers need it

05.06.2025 17:23 β€” πŸ‘ 6    πŸ” 1    πŸ’¬ 1    πŸ“Œ 0

Connection management in Fabric is a mess. That entire area needs to be revamped and made modern.

03.06.2025 20:54 β€” πŸ‘ 5    πŸ” 2    πŸ’¬ 2    πŸ“Œ 0
Connecting to Excel in SharePoint Online from Power Query (Lazy Tutorial)
YouTube video by BI Polar Connecting to Excel in SharePoint Online from Power Query (Lazy Tutorial)

"using the file connector (which requires a gateway) to connect to files in SharePoint instead of the SharePoint or Web connectors (which do not require a gateway) is a top 3 rookie move at my company. The product itself does not make it easy either youtu.be/kpRrK89tRU4?...

04.06.2025 13:27 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Lmao dicks is kinda meh I agree but burgerdisaster isn't even close to Red Mill, uneedaburger, a or even kidd valley

01.06.2025 18:45 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Pure Python or any spark?

27.05.2025 22:36 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Think "power bi desktop" is from the store

10.05.2025 13:37 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Store app vs web install?

10.05.2025 13:20 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

The movie adaptation is basically just him reading the best lines in the book

29.03.2025 03:29 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

My in laws are all doctors and nurses. They have their own language and are unaware that it's tedious and snobby. Dividing something into pieces is "aliquoting." "I don't have a fever" is "I'm afebrile." At Thanksgiving they talk about pipetting the turkey.

24.03.2025 15:13 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Cannot emphasize how much CRUD APIs and availability in pro are essential here. I will struggle to take myself seriously if I have to regularly explain to confused users the difference between an "app" and an "org app" while discussing -yet another- way to distribute content in this platform

23.03.2025 23:42 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

trading one set of paper cuts for another one if I move to org apps. Also only available on fabric capacities rn. Silly that it's not available for all workspaces. I know it's still in preview, but I'll bet you a pineapple pizza with provel it will have its own missing pieces that never get filled

23.03.2025 23:21 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Only chance to get a feature like that these days is if copilot does it

23.03.2025 22:40 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

As always, #ItDepends

20.03.2025 15:53 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

It is, but in large datasets those PQ steps may take a long time to compute and require loading way more uncompressed data into memory than DAX would

20.03.2025 14:39 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

If your table uses fixed start and end dates, PQ is the way to go. If you need dynamic dates based on your data as it refreshes, DAX (without CALENDARAUTO) is best

20.03.2025 14:27 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Please go through the proper channels

09.03.2025 04:47 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

We have explicit environments for every repo in our org with unique parameter files that get picked up when a deployment happens in that environment so variables are usually replaced with key:value pairs, not by finding a guid or a string and replacing it with another

08.03.2025 17:50 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Gave it a whirl this week using GitHub actions, and it handles basic publishing really well. Doesn't handle post deployment tasks yet, which are important for semantic models mostly. I also think the find/replace could be better, gets clunky if you proliferate feature branches imo

08.03.2025 17:46 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

Even if you're looking at eastern Washington, Wenatchee, Walla Walla, Chelan, cle elum, hell even Spokane are all objectively better than anything around the Hanford reach. It's just a series of speed traps with decent Mexican food

23.02.2025 23:13 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Yakima to the tri-cities is so much worse

23.02.2025 20:36 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

IMO sometimes, depending on the number of values and the variability of the data, they can become informative slicers that make better use of real estate.

23.02.2025 01:19 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image Post image

Woofers were rescued from another pair with cabinets that were in rough shape

20.02.2025 20:59 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Recently finished refurbishing my dad's Advent Loudspeakers from the 70s. He's not famous but they have new woofers inside the original cabinets and new grills. They look and sound great! And the only tooltips and sparklines I had to be concerned with was a soldering iron

20.02.2025 19:35 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Fun fact, if you want to deploy a pbip file with the fabric create/update item APIs, you can't use the the byPath property you have to build the byConnection object and replace it at run time

20.02.2025 14:49 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

My plane veered off the tarmaaaaaac

16.02.2025 21:28 β€” πŸ‘ 6    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Book cover of the "free money from the government" ads from the 90s

Book cover of the "free money from the government" ads from the 90s

Wonder if the doge edgelords have found this guy yet

16.02.2025 03:57 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

@excelmiddleware is following 20 prominent accounts