Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to consolidate multiple sheets into another workbook and I am seeing multiple tables.
Please find the below image and help.
How to remove duplicate tables?
Hi @sumanthhc08
What you are seeing there are Sheets (Those with the names) and their corresponding tables. I always import the tables only. When you load them in, you have append all the tables together. Home > Append tables. Untick enable load on the tables you imported and use the new Appended table in the report. (Do not delete these tables afterwards, otherwise the Append will fail)
Thanks
Joe
If this post helps, then please Accept it as the solution