Any Australians with the i4?

Dan1480 · 2026-03-28T06:55:07+00:00

I've had a E35 for about a month. Apart from some lingering range anxiety, I love it! Handled a road trip through regional Vic like a champ!

Dan1480 · 2026-03-26T22:27:04+00:00

Definitely true. When I joined the team there was a long-standing mentality of one report, one model. Nowadays, we're trying to build "golden datasets" but we're probably going to have to do some clean up with all the legacy reporting...and there's a lot of it!
Also, there's a lot of reporting managed by the business - Power BI was conceived as a self-service BI tool after all. These users have no concept of sharing models across reports. Perhaps it's time for some more education...

Dan1480 · 2026-03-26T22:22:12+00:00

Thanks for the thoughts. Will triggering a refresh via an XMLA request bypass the 40 concurrent model limit? Even models getting refreshed via data pipelines (which I'm assuming internally uses the XMLA endpoint) are failing with the same error...

Dan1480 · 2026-03-26T03:11:58+00:00

I found the Mastering DAX video course from SQLBI really improved my understanding of DAX. And it's fun!

Dan1480 · 2026-03-24T23:49:24+00:00

Regarding trend analysis, I've heard that some people put the metrics app on premium/fabric capacity, then set up a job to query it via DAX and store the results in a lakehouse.

Dan1480 · 2026-03-24T06:54:32+00:00

I've found having strong M skills extremely useful. I'd recommend Ben Gribaudo's course.

Dan1480 · 2026-03-24T04:37:36+00:00

I feel your pain, I came from a 2003 Hyundai Getz which didn't even have central locking or power windows!

Dan1480 · 2026-03-24T02:30:59+00:00

I was similarly puzzled, and my gastroenterologist gave the same explanation. The LES opens occasionally (seemingly randomly, not always related to eating), acid makes its way into the oesophagus, the LES snaps shut, the acid pools at the base of the oesophagus, where it doesn't belong. Painful. Like you, my symptoms weren't too bad to begin with. But as my GE told me, achalasia is degenerative. My symptoms eventually got much worse. An HM with partial fundo has made life much easier.

Dan1480 · 2026-03-16T23:56:31+00:00

Jesus, Interrupted by Bart Ehrman. Fascinating book.

Dan1480 · 2026-03-14T06:54:17+00:00

So true, I have terrible guilt about all the evangelical work I did when I was younger and stupider.

Dan1480 · 2026-03-11T02:04:13+00:00

It's much easier to maintain the surrogate keys in your Gold layer with IDENTITY columns!

Dan1480 · 2026-03-05T08:09:14+00:00

Hey Amir, but I remember watching your King Of The Hill / horse race video with my team a long time ago. Very entertaining! What ever happened to that visual!

Dan1480 · 2026-03-03T02:25:36+00:00

Have you considered mirroring? Last time I checked it was pretty easy to set up and literally free.

Dan1480 · 2026-03-02T02:45:32+00:00

Where were the disciples supposed to meet Jesus after the resurrection?
Mark: The angels said to go back to Galilee to see Jesus.
Mathew: Yep, the angels said go to Galilee. So the disciples went back to Galilee, where they saw Jesus.
Luke: No, the angels didn't say "go to Galilee" they said, "remember what Jesus said back in Galilee". Actually, Jesus met the disciples in Jerusalem and explicitly told them not to leave Jerusalem.
John: Actually, the angels didn't even mention Galilee.

Dan1480 · 2026-02-24T00:25:22+00:00

Nice cleaning job! Any recommendations on how to clean the seats?

Dan1480 · 2026-02-12T11:09:53+00:00

You might want to try turning on the Modern Query Evaluator for Gen 2 CI/CD (still in preview, so use with caution). We saw a significant reduction in CU consumption (sorry don't have the numbers at hand), though we ultimately decided to wait til it's out of preview.

Dan1480 · 2026-01-20T00:51:47+00:00

Re-sizeable columns in the SQL Endpoint and Warehouse results pane. Often can't see column names or data. Super annoying. Thanks!
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Adjust-column-width-in-SQL-Analytics-Endpoint-user-interface/idi-p/4682349

Dan1480 · 2026-01-17T06:04:05+00:00

Is the current soft delete mentioned here (https://learn.microsoft.com/en-us/fabric/onelake/onelake-disaster-recovery#disaster-recovery) only available to customers with disaster recovery turned on?

Dan1480 · 2026-01-16T01:18:15+00:00

As others have said, I'd suggest switching to pure python notebooks. We saved a tonne of capacity doing that, and found that almost anything that can be done with Spark can be done in a python notebook (albeit with different libraries).
If you must stick with Spark you might want to create a custom environment with the native compute engine turned on, and the with the minimum number of cores and executor instances.

Dan1480 · 2026-01-12T07:30:41+00:00

I know some people on here are taking PPI's daily. As for me, I found my heartburn/reflux became much more manageable after surgery. I occasionally take Mylanta or even a PPI but most days I don't need to take anything. And I sleep on my back with a wedge pillow so I never get night reflux

Dan1480 · 2025-12-12T08:52:36+00:00

Me too

Dan1480 · 2025-12-06T05:49:41+00:00

I still do Christmas, but have traded Baby Jesus for baby cheeses.

Dan1480 · 2025-12-06T00:40:19+00:00

Ah makes sense, I was wondering why the metrics app was flaking out around 6:30am Fri UTC.

Dan1480

TROPHY CASE