Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data Modeling - Monthly Data from Multiple Cloud Instances

Hello! I am diving into the world of PowerBI and looking for some advice from you expert users.    My company offers a SaaS product to other companies via segmented, private clouds. For example, we...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi Anonymous ,
    I see no reason why to create one table per instance. Append them all together with one column for the customerID. Then add a date and customer table.

    As a rule of thumb for Power BI you can assume that if tables have the same column names, they should be merged into one table.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
looking good to me.
1) No worries about scalability of single table vs. separate tables. Just the opposite: Due to PBIs compression mechanism, having it in one table will use less space.
2) You must handle these eventualities in your measures: Filter out blank rows where you want to ignore rows without entries in certain columns.