Solved: Connecting two data sets

Anonymous · ‎07-05-2023

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 · ‎07-07-2023

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.

View solution in original post

AnkitKukreja · ‎07-11-2023

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.

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

AnkitKukreja · ‎07-11-2023

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.

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904