Forum Discussion
Several workspaces with the same semantic model-How to create a single master model (or dataset)
Hi chat_peters ,
Golden Dataset Concept:
A golden dataset represents a unified, high-quality version of your data that serves as the single source of truth. It consolidates information from various sources, ensuring consistency and accuracy.
The goal is to create a single dataset that can be used across different workspaces or reports, reducing redundancy and maintenance efforts.
Modern Approach:
The traditional method involved duplicating datasets across workspaces. However, a more effective approach is to use shared datasets.
Here’s how it works:
Publish your Golden Dataset to a dedicated Golden Workspace.
Create a new thin workbook (report) pointing to the Golden Dataset.
Publish this thin workbook to other workspaces.
Power BI automatically manages the link back to the Golden Dataset for youBelow is the link will help you:
What is Golden Dataset in ML & PowerBI? (Answered) (dataresident.com)
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi chat_peters ,
Golden Dataset Concept:
A golden dataset represents a unified, high-quality version of your data that serves as the single source of truth. It consolidates information from various sources, ensuring consistency and accuracy.
The goal is to create a single dataset that can be used across different workspaces or reports, reducing redundancy and maintenance efforts.
Modern Approach:
The traditional method involved duplicating datasets across workspaces. However, a more effective approach is to use shared datasets.
Here’s how it works:
Publish your Golden Dataset to a dedicated Golden Workspace.
Create a new thin workbook (report) pointing to the Golden Dataset.
Publish this thin workbook to other workspaces.
Power BI automatically manages the link back to the Golden Dataset for you
Below is the link will help you:
What is Golden Dataset in ML & PowerBI? (Answered) (dataresident.com)
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for responding back. If I am understanding correctly, I still need to create one model from all the models across the workspaces and call this my golden dataset. My question is how do I do that? I have the same model using the same tables across 100 workspaces because we use workspace isolation model for stricter data controls. Lets say each of these workspaces represent a different customer. They're basically looking at the same report but just with their data.
Let's say customers are A through Z and I have 26 workspaces. Let's also say the only fact table in each of these workspaces is Fact_sales and I want to look across all 26 customers fact tables to do some benchmarking. My question is how do I create that one fact table combining all 26 fact tables in 26 different workspaces, in the power bi service?