Forum Discussion
Create a 'Golden Dataset' with a super complex database data model
SoniaB102 doesn't matter how many tables or large your database is, as a best practice you want to thrive for Star schema in Power BI regardless of how the table is maintained in the backend.
I have done many large projects with a lot of rows (size of database) and the golden dataset worked perfectly, never ran into any issue until now.
Now the composite model is available, for some ad-hoc requirements, maybe it will be easier to link other data sources with the golden dataset. I will highly recommend using this approach.
End of the day, it is easy to manage, with better security, few people are allowed to touch the model, make changes, add measures, etc. I find it a win-win for my projects.
This is my experience. I'm sure others have different thoughts/experiences.
SoniaB102 doesn't matter how many tables or large your database is, as a best practice you want to thrive for Star schema in Power BI regardless of how the table is maintained in the backend.
I have done many large projects with a lot of rows (size of database) and the golden dataset worked perfectly, never ran into any issue until now.
Now the composite model is available, for some ad-hoc requirements, maybe it will be easier to link other data sources with the golden dataset. I will highly recommend using this approach.
End of the day, it is easy to manage, with better security, few people are allowed to touch the model, make changes, add measures, etc. I find it a win-win for my projects.
This is my experience. I'm sure others have different thoughts/experiences.
Thanks for your response. That's great info and helps to know you have used a Golden Dataset multiple times on big datasets - I shall peservere and also look into composite models!
