Forum Discussion

rdnguyen's avatar
rdnguyen
Icon for Helper V rankHelper V
3 years ago

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

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...
dataflow
Need Help
Tips and Tricks
rdnguyen's avatar
rdnguyen
Icon for Helper V rankHelper V
3 years ago

Hi lbendlin and all,

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

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    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.