Multiple Tables in a dataset or just one table per dataset?

[areed1192]

My company is in the process of migrating from Tableau to Power BI and I want to make sure we kick this off right. My question is when we are building out our datasets what makes the most sense when it comes to organizing tables? For example, should I create multiple datasets with just a single table, or should each dataset have multiple tables in them?

If we go the single table per dataset route, the thought was we then create "Model" dataset that connects to each of the individual tables. 

Has anybody approached Power BI in this fashion? What was your experience approaching it this way? Any concerns that popped up down the road? If you have a different approach I would love to hear that as well.

[tackytechtom]

Hi @areed1192 ,

Best practice is to model the data in a dataset as a star schema and not with flat tables. Here a link that explains the concept, but there is more material when it comes to the data modelling part (see the navigation pane on the left):

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/