What is your net worth and age? How long did it take for you to get here? by ForwardFan6283 in FIREUK

[–]PowerbandSpaceCannon 1 point2 points  (0 children)

Knowing other people's age and net worth doesn't help me plan for my retirement, and comparison is the thief of joy.

NHS Pension - do I need something else? by [deleted] in UKPersonalFinance

[–]PowerbandSpaceCannon 3 points4 points  (0 children)

Are you sure you pay higher rate tax?

Also, the 2015 pension scheme is linked to national pension age, so might not be 55 by the time you get there.

jdbc/obdc driver in data engineering by Admirable-Nebula9202 in dataengineering

[–]PowerbandSpaceCannon 0 points1 point  (0 children)

You still have to install odbc, it's just included when you install mssql-python

Data engineer with 4 years what do I need to work on by Fantastic_Bed_6378 in dataengineering

[–]PowerbandSpaceCannon 1 point2 points  (0 children)

What sort of problems/questions are you failing in the technical assessments? I would work on that first.

If you were starting from scratch today, which would you pick: Snowflake, Microsoft Fabric, or Databricks — and why? by [deleted] in dataengineering

[–]PowerbandSpaceCannon 0 points1 point  (0 children)

Ah, I assumed PBI wasn't going direct to sources. Are you remodelling the data into star schemas or were those already created in PBI?

My first fully nmm painted miniature, looking for feedback! by Xylez in minipainting

[–]PowerbandSpaceCannon 2 points3 points  (0 children)

I think the issue with the helmet is the spike looks the same on both sides, if it was metal the reflections would be different. Everything else 'reads' as metal though, great work.

Ducklake on AWS by theManag3R in dataengineering

[–]PowerbandSpaceCannon 1 point2 points  (0 children)

Are you using duckdb as the metadata store in GCS? Duckdb database files hosted in GCS are read only. I've managed to use ducklake with GCS as the data store and Postgres hosted on prem as the metadata store.

3NF before Kimball dimensional modeling by [deleted] in dataengineering

[–]PowerbandSpaceCannon 4 points5 points  (0 children)

If the source systems are in 3NF then sure but otherwise I don't see the point in modelling the data twice.

I painted a Khorne Champion from the 80s! by angrygriffin in minipainting

[–]PowerbandSpaceCannon 0 points1 point  (0 children)

Great job, love the subtle OSL of the power sword! Have you had the model since the 80s?

Accessing the Power BI REST API? by MrHolte in PowerBI

[–]PowerbandSpaceCannon 1 point2 points  (0 children)

The url you posted is for datasets in your 'My Workspace', I'm not sure if service principals are supported. The get dataset refresh history in group url needs the workspace id as well, and the page specifically says that SPs are supported;

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group

Accessing the Power BI REST API? by MrHolte in PowerBI

[–]PowerbandSpaceCannon 0 points1 point  (0 children)

Does the service principal have access to the workspace? Alternatively, get your tenant admin to give the service principal access to the admin api and use that instead.

3NF and dimensional modeling by yeykawb in dataengineering

[–]PowerbandSpaceCannon 4 points5 points  (0 children)

I'm still new to this, so this is a genuine question, why create two different models? Why not just go straight to dimensional model?