How do you store Dimensions propagated from Fact Table on Power BI Service?

[rdnguyen]

Hi there,

Anyone kindly suggest your way in storing Dimensions (dataflow) propagated from Fact Table(s) on Power BI Service please?

I would like to learn how you setup refresh trigger for Dimension workspace if you store Dimension group separately

[rdnguyen]

Hi @lbendlin and all,

From your experience, are you wrapping Dimension in the same Dataflow with Fact table?

[lbendlin]

You can choose whatever normalization level is appropriate for your business scenario.  Remember that dataflows are Parquet files. Any transforms you do to a dataflow (after the initial ETL) are a waste of resources  (in my opinion).  One could argue that dataflows are only effective for facts, but there are some high cardinality dimensions that can potentially benefit from dataflows.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?