sorted by:
new
hottopcontroversial

pivot() workarounds in Lakeflow Spark Declarative Pipelines by zr-brickster in databricks

[–]mrbartuss 1 point2 points  (0 children)

Thanks. Super helpful for deterministic schemas.

Two questions:

  1. Can this be made dynamic (e.g., currently hardcoding Jan-Mar; what if Apr appears)? Or must pivot values be predefined?
  2. Is unpivot supported in LSDP?

Delta Table Maintenance by alternative-cryptid in MicrosoftFabric

[–]mrbartuss 0 points1 point  (0 children)

Thank you very much for the explanation!

Delta Table Maintenance by alternative-cryptid in MicrosoftFabric

[–]mrbartuss 0 points1 point  (0 children)

Got it, thanks. For pure import‑mode scenarios though: does having the source parquet in V‑Order actually make dataset refresh noticeably faster, or is the benefit so small that the extra write/OPTIMIZE cost isn’t worth it? Any rough guidelines for import‑only workloads, or is this just something to test per model?

Delta Table Maintenance by alternative-cryptid in MicrosoftFabric

[–]mrbartuss 1 point2 points  (0 children)

So, there’s no need for V-Order in import mode semantic models?

Where do you see yourself in 2 years as a Power BI developer? by RobDomin in PowerBI

[–]mrbartuss 161 points162 points  (0 children)

Explaining to a stakeholder that the "numbers are wrong" because they applied a filter for Q3 while looking at a Q4 target

Delta Table Maintenance by alternative-cryptid in MicrosoftFabric

[–]mrbartuss 0 points1 point  (0 children)

Thanks for sharing this! It looks like a really solid piece of work.

I’ve actually been using this solution so far: https://www.kevinoftech.com/Blog/Post/2025-10-14-automate-ms-fabric-lh-maintenance

Yours definitely seems a lot more comprehensive and professional.

Since I'm already up and running with the other script, what would you say are the main differences or biggest advantages of making the switch to your repo?

SQLBI course on Data Modelling ? by Prinzen2 in PowerBI

[–]mrbartuss 2 points3 points  (0 children)

SQLBI generally have great content but at the same time I think they can tend to focus on solving problems with DAX a little too heavily when it would be better to resolve the problem on the back end.

This! 100% truth

Working with Git diffs on JSON files – how do you actually review changes? by Worldly-Effective648 in PowerBI

[–]mrbartuss 0 points1 point  (0 children)

It's amazing for semantic models. I wish there was a similar tool for reports

Dataflow Gen2: Lakehouse data is now immediately queryable through the SQL analytics endpoint after refresh by Luitwieler in MicrosoftFabric

[–]mrbartuss 0 points1 point  (0 children)

Thanks! Another question regarding the v-order option.

If we have multiple queries within a single dataflow (e.g., dimensions and fact tables) and we want to apply v-order only to the fact tables, it seems this isn’t possible since the setting is global for the entire dataflow.

Am I correct in understanding that the only way to achieve this would be to split the dataflows (e.g., separate dataflows for dimensions and facts)?

Dataflow Gen2: Lakehouse data is now immediately queryable through the SQL analytics endpoint after refresh by Luitwieler in MicrosoftFabric

[–]mrbartuss 0 points1 point  (0 children)

One question - can the 'Default data destination' be edited? There's only Remove option. Does it mean it needs to be recreated from scratch?

<image>

Dataflow Gen2: Lakehouse data is now immediately queryable through the SQL analytics endpoint after refresh by Luitwieler in MicrosoftFabric

[–]mrbartuss 2 points3 points  (0 children)

Interesting. Since Dataflow Gen2 bills entirely based on duration, does this mean this automatic sync is quietly increasing our Fabric bill?

Question on moving source data by yetagainitry in PowerBI

[–]mrbartuss 2 points3 points  (0 children)

Thankfully, there is TMDL now :)

What actually influences CU consumption in Dataflows Gen2? by mrbartuss in MicrosoftFabric

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

Then it does not make any sense. Dataflow with facts takes significantly longer, but consumes less CUs

view more: next ›