Connecting two data sets

[Anonymous]

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 🙂 

[v-jingzhang · Accepted solution]

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.

[AnkitKukreja · Accepted solution]

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.

[v-jingzhang · Accepted solution]

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.