Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Merge Files On Demand in PowerBI

Hello,

 

I am moving from another BI tool to PowerBI and I am trying to replicate/meet the functionality of the other tool. We were using a somewhat "merge data on demand tool" so any user could upload their "merge file" and that would be merge with the central data source. That "merge file" would need to contain 1 of the 3 keys to merge back to the central data source. Users would then filter on some characteristics from the central data source and export their merge file.

 

I am trying to mimic something somewhat similar in PowerBI but I'm not sure the best way to approach it. Possibly each file is a new table in the dataset but I'm not sure how I can pre-create relationships between tables that don't exist yet? Or I could try to merge them all into one table but the headers of the files are going to be different?

 

Any suggestions for how to tackle this problem or slightly adjust my process to meet the end goal of users being able to on-demand combine/filter their data in PowerBI? (I understand other tools might do this better but I want to try to achieve in PowerBI first)

 

Thanks in advance for the help!

1 REPLY 1
Greg_Deckler
Super User
Super User

Not sure if this will help or not but I wrote this article a while back:

 

https://social.technet.microsoft.com/wiki/contents/articles/32915.power-bi-merge-query-with-m.aspx

 

Might give you some ideas. I'll think some more on this topic. I'm wondering if perhaps you could pre-create your main tables and then your merge tables and use functions like NATURALLEFTOUTERJOIN to create a "final" table. This would all be pre-created so the user would only have to point the query for the "merge" table to their data and presto!


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.