Forum Discussion

GulianiG's avatar
GulianiG
Helper II
2 years ago
Solved

Best Practice for creating Static Dimensions Table?

Hello Experts, I'm working on Dataflows and have a question about creating dimension tables for a fact table with 3 years of event history. Context: Fact table with events from the...
Need Help
  • aj1973's avatar
    aj1973
    2 years ago

    Hi GulianiG 

    Both approaches are ok in a dataflow, however in a dataflow you can't relate tables together nor you can use DAX.

    I would go with creating dimension tables in Sharepoint hence when someone other than the owner of the Dataflow wants to make changes, he will do it in Sharepoint(only the owner of the dataflow can make changes on it).

    Performance wise, Dataflows are sources of truth for semantic models built on top of them, so they should be ok. Rather watch out the performance of the semantic models.

     

aj1973's avatar
aj1973
Community Champion
2 years ago

Hi GulianiG 

Both approaches are ok in a dataflow, however in a dataflow you can't relate tables together nor you can use DAX.

I would go with creating dimension tables in Sharepoint hence when someone other than the owner of the Dataflow wants to make changes, he will do it in Sharepoint(only the owner of the dataflow can make changes on it).

Performance wise, Dataflows are sources of truth for semantic models built on top of them, so they should be ok. Rather watch out the performance of the semantic models.