Forum Discussion
Connecting two data sets
Essentially I have two data sets which are talking about the same thing, let's say sign ups. But one already has sign-ups per month and the other has sign-ups recorded as single items. Both of these data sets come from SharePoint. And I would like to merge these into one SP/if not, in one visual in power bi. Is this possible?
Any help would be appreciated 🙂
Hi Anonymous
If they have some common columns, you may have a look at the Merge queries feature in Power Query. It should be helpful.
Merge queries overview - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Hi Anonymous
You can create a new SharePoint where you can merge these files or you can use merge in Power BI to get data in a single table. If you can share the table structure then it might open other options to be explored.
2 Replies
Hi Anonymous
If they have some common columns, you may have a look at the Merge queries feature in Power Query. It should be helpful.
Merge queries overview - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Hi Anonymous
You can create a new SharePoint where you can merge these files or you can use merge in Power BI to get data in a single table. If you can share the table structure then it might open other options to be explored.