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. Since this data is not correlated so far there was no need to present both in one report.
Now there is a requirement to show some values from both datasets. I see 2 possibilites:
a. dashboard (business users would like to avoid such solution - only reports should be considered)
b. make direct query connection to both datasets but this would require to add them to local model which then creates 3rd dataset and main idea was to avoid maintaining new datasets
Is there any third possibility that I don't see at the moment?
Thanks in advance!
4 Replies
stankda , What you are trying is the possibility , as far as I know
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
