Data Model

[brewerc2]

I am new to Power BI and trying to understand best practices for building an effective data model for my reports.  I would like to share data sets accross mutliple reports.  It is import set up the data tables effectively so these datasets can be used by other users with an end goal to create a meaningful data dictionary for data export.  Are there good resources I should look at or best practices? 

[Idrissshatila]

Hello @brewerc2 ,

yes, check the star schema data model concept 

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

and for sharing a dataset with different reports, use the following 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡