Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi guys,
I am working on a dataset where I want to combine multiple nested tables into one big table. The nature of the nested tables are in the attached screenshots below; each nested table contains a "Unique" column which is common to all of them and I want the end result to contain one Unique column and all the rest of the columns from each nested table in one table.
I think I am right in saying that, I am trying to join all these tables dynamically.
I would really appreciate it if you could suggest me a way.
Many thanks,
John 😊
Example table 1
Example table 2
Below is a screenshot of the end goal.
End goal
not completely clear what you want, but I would try this strategy:
1) expand the column of tables
2) group the data of the large table obtained on the Unique column and choose not to aggregate on any column but to keep all the rows.
If you attach a file with some dummy tables I can write you the single steps in detail.
I now have a sample dataset but not sure how to upload it here. Any thoughts? Thank you.
Hi @JohnFonz
You can refer to this blog https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Best Regards,
Community Support Team _ Jing
Hi Rocco,
Thank you for the response.
This is a method I tried but dropped for performance reasons. Each table contains 8760 rows and the "Unique" column contains 8760 distinct values. So, when you expand, group with or without aggregation, it slowed down the query significantly. I am working on dummy tables, will update it here soon.
Many thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
10 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |