Forum Discussion
Creating 1 visual from 5 different tables
Hi,
I have 5 different tables, 5 worksheets in 1 excel file. i've uploaded this to power BI as data set. Is it possible to combine the data from these 5 worksheets into 1 visual? for example clustered columns visual, each cluster will be composed of 5 columns from 5 worksheets.
Thanks!
Hi Rigby16 ,
You can try append query in power query editor. This function allows you to combine mang tables with the same structure.
For more details you can check it in this link.
Append queries - Power Query | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Thank you Aditya for the advise. This is my first time doing data model as i usually use 1 table for power BI. I tried to make relationships between the tables however it requires to use many-to-many. When I tried creating the cluster columns visual the value was not seggrerated but it reflects the total number of tickets in the table and not in a per month basis. 😞
just to give a description of the tables, the 5 tables consists of same columns with data from different sites: ticket number, date, severity, status. i want to show in a cluster column the number of tickets per month per site.
thanks!Hi Rigby16 ,
You can try append query in power query editor. This function allows you to combine mang tables with the same structure.
For more details you can check it in this link.
Append queries - Power Query | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
