Forum Discussion
Power BI Datasets (How do you do it)
I currently have 1 single large dataset "Current Setup" where all thin reports point to pull data. I have noticed that any issues with a single data source can prevent the entire Power BI Dataset from refreshing and ALL down stream thin reports are at risk.
To reduce risk to all reports, I propose to split the large dataset into several smaller siloed datasets "Proposed Setup".
My concern is that a thin report that uses data from two or more datasets will need to use the shared Dimension tables. What would be the best way forward to deal with this scenario?
Hi Anonymous ,
You could learn more about source group.
A source group is a collection of items (tables, relationships, etc.) from a DirectQuery source or all import sources involved in a data model. A composite model is comprised of one or more source groups. Consider the following examples:
- A composite model that connects to a Power BI Dataset called Sales and enriches the dataset by adding a Sales YTD measure which is not available in the original dataset. This model consists of one source group.
- A composite model that combines data by importing from a table from an Excel sheet called Targets and a CSV file called Regions, as well as making a DirectQuery connection to a Power BI Dataset called Sales. In this case there are two source groups (see image below):
- The first source group contains the tables from the Targets Excel sheet, as well as the Regions CSV file.
- The second source group contains the items from the Sales Power BI Dataset.
If you added another DirectQuery connection to another source, such as a DirectQuery connection to a SQL Server database called Inventory, the items from that source will be added as another source group:
refer:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
Best Regards
Lucien
2 Replies
Hi Anonymous ,
You could learn more about source group.
A source group is a collection of items (tables, relationships, etc.) from a DirectQuery source or all import sources involved in a data model. A composite model is comprised of one or more source groups. Consider the following examples:
- A composite model that connects to a Power BI Dataset called Sales and enriches the dataset by adding a Sales YTD measure which is not available in the original dataset. This model consists of one source group.
- A composite model that combines data by importing from a table from an Excel sheet called Targets and a CSV file called Regions, as well as making a DirectQuery connection to a Power BI Dataset called Sales. In this case there are two source groups (see image below):
- The first source group contains the tables from the Targets Excel sheet, as well as the Regions CSV file.
- The second source group contains the items from the Sales Power BI Dataset.
If you added another DirectQuery connection to another source, such as a DirectQuery connection to a SQL Server database called Inventory, the items from that source will be added as another source group:
refer:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
Best Regards
Lucien