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 Dimension workspace if you store Dimension group separately

Dataflow
Need Help
Tips and Tricks

3 Replies

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

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

  • 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.