Power BI Datasets (How do you do it)

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