Facts and Dims

dpjatochh — Wed, 04 Dec 2024 09:15:14 GMT

Hi everyone,

How does everyone approach modeling in Dataflows Gen2? For our client it seems easier to do it with a dataflow because they are not on a sufficient SQL or notebook level.

Would you create a dataflow for every fact/dim? It makes sense for me to keep it seperate. But i'm also thinking - if multiple facts/dims use the same source tables that we might combine them into one dataflow

Thanks

Re: Facts and Dims

Pragati11 — Wed, 04 Dec 2024 22:57:58 GMT

HI dpjatochh ,

I would suggest here to go by Dataflow best practices.

You can have first dataflow to bring in your raw data. (Staging Dataflow)
You can have second dataflow to do all the transformations like creating DIM and FACT tables. (Transformation Dataflow)
Finally you can have a dataflow having all your final transformed tables (DIMS and FACTS); which you can use further to create your semantic model. (Output Dataflow)

Staging DF --> Transformation DF --> Output DF

You can read about dataflow best practices here:

https://learn.microsoft.com/en-us/power-query/dataflows/best-practices-developing-complex-dataflows

topic Facts and Dims in Dataflow

Facts and Dims

Re: Facts and Dims