Forum Discussion
Getting data from 2 datasets into one report
Hi Current background: my organization have 2 big datasets and idea is to keep only 2 datasets (each contains data from different source) and to build reports based on one dataset or the other. ...
HI stankda,
You can take a look at the following link about creating reports based on different datasets(they can be hosted in different workspaces) if helps:
Create reports based on datasets from different workspaces - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
Anonymous
hi, this article is about live connection to one dataset. My scenario are two datasets that I need to combine without creating 3rd, local one.
HI stankda,
You can create two query tables and copy and rename the second table 'source' step to the first one, then use the combine function to merge these two query steps if they have the same data structure. (table column amount, names, and data types)
Table.Combine - PowerQuery M | Microsoft Docs
Regards,
Xiaoxin Sheng