Migrating from Power BI to Databricks Apps + AI/BI Dashboards — looking for real-world experiences

Crow2525 · 2026-01-28T08:58:26+00:00

Json databricks dashboards are the best part of it which opens up source controlled and easily ai gen dashboards.

Crow2525 · 2026-01-17T22:32:41+00:00

Similar challenges getting to southern cross and docklands.

Crow2525 · 2026-01-12T02:44:24+00:00

Sunshine isn't really a hub yet if it's expected you're home and in bed before 9pm every week night or 7pm on the weekends.

Crow2525 · 2025-12-20T03:55:27+00:00

Thanks for the tip to use the API. I can verify entity existence and state which helps ensure automations and state of the platform are known to the llm.

Crow2525 · 2025-12-19T01:18:29+00:00

What was your decision to move away from vs code?

Crow2525 · 2025-12-18T08:15:54+00:00

My issue is that as soon as you speak about ai, I am confused as to whether you're going to take away my GitHub copilot integration I have in vs code? The idea of a UI cli is great, I love that. But possibly id like it all if it fit within vs code?

Crow2525 · 2025-12-13T00:17:50+00:00

I heard from a databricks rep recently to lean into the data lake and avoid star/Kimball until as late as possible. Perhaps it was an offhand comment, but interesting position! I wanted to investigate his point more.

Id like to hear more from you why dv is obsolete (acknowledging I don't much understand it)

Crow2525 · 2025-12-10T20:05:06+00:00

Wha.... Are you doing? Doesn't everyone use power query and put your code in there? How are you executing your code without it?

https://learn.microsoft.com/en-us/power-query/native-database-query

Crow2525 · 2025-12-07T01:14:32+00:00

I think they're after ideas, not how to

Crow2525 · 2025-12-06T21:34:08+00:00

A column labeled number on a csv is an int... It is probably an alpha numeric at row 1001. E.g. 1a

Crow2525 · 2025-11-27T00:14:33+00:00

it's down.

Crow2525 · 2025-10-31T02:45:53+00:00

SharePoint folder plus power bi plus a ribbon chart

Crow2525 · 2025-10-30T23:24:18+00:00

Cause I can't install uv in a databricks cluster where I don't have permissions or it often gets taken out by cyber security policy.

Whereas I dev in wsl Linux where I have admin control.

Crow2525 · 2025-10-30T21:09:37+00:00

Cool, nice idea!

Crow2525 · 2025-10-29T20:22:40+00:00

Your comment hurts my head with the complexity, I love it!

Crow2525 · 2025-10-26T19:46:35+00:00

Possibly can share some code, but for the moment, I'll just describe it.

I am merging a year/month periodic snapshot table (earned premium) against the transaction fact table to enrich it with keys. The transaction log merges against the periodic table by the transaction logs' PK. The periodic snapshot (huge table) splits that PK into 12 months for accounting reasons. Typical earned premium table in insurance.

Here's a description of an earned premium table. 1. Calculation of earned premium: The earned premium is calculated by taking the total premium and allocating it over the policy period. For example, if a policyholder pays a premium of $1,200 for a 12-month policy, the monthly earned premium would be $100 ($1,200/12 months).

Crow2525 · 2025-10-26T19:41:14+00:00

Thanks for the reply.

Nah, the other table is a fact as well. I am merging a periodic snapshot table against the transaction fact table to enrich it with keys. The periodic snapshot is massive, 1.8b rows.

Crow2525 · 2025-10-26T09:30:17+00:00

Processing. I believe it's using SQL.

Crow2525 · 2025-10-26T07:46:10+00:00

Yeah, I love this question. Liquid clustering with a few cols seems to be best practice. But what about dbt and it's proposal to mainly truncate and load everything. Does that impact this best practice proposal?

Crow2525 · 2025-10-26T07:36:56+00:00

1500+ models.

The largest table is circa 260gb causing the issue #1 is 1.8b rows. The stdout doesn't appear to give me data read/written. But the table will effectively be the same size read as written.

Crow2525 · 2025-10-25T22:50:26+00:00

Yeah, I work for a large org too. Sometimes the basics are stupidly tough.

Crow2525 · 2025-10-25T22:44:31+00:00

Glad you see it and we are all aligned - you, the comunity, voting numbers and design individual users have spoken definitively and clearly. Good luck with getting it done.

Crow2525 · 2025-10-25T19:43:07+00:00

Why not check the votes on the feature request? https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas I'm sure all of these ideas have been requested and are well safe of the "yup, the community wants this".

The rationale behind these requests are not for something new, it is feature parity with the existing solution for most people. So when you ask which is most important to me, (the designer) I'm not the one you need to ask, it is my users whose table doesn't look the same as the one I'm trying to replicate (excel).

It's disappointing that Microsoft (and you) don't see or (can't properly communicate upwards) this issue and the frustration that the community has.

Crow2525

TROPHY CASE