How to consolidate multiple tables in one table using power bi

0 votes

Hi, I have pdf wanted to upload in power bi, in that pdf I have 4 columns (city, unit name, contact, address) and 8 tables with the same column name. I wanted to consolidate all tables into 1 table.

City unit name contact address
bhopal mp nagar 8770761966 plot no 45 hoshangabad road bhopa
indore 56 dukan 3543657334 dukan no. 56 chappan road indore

Table 2

City unit name contact address
Prayagraj sangam 4534563345  kuch bhi addrss sample 
Rewa maple 8775938587 lknav fni ample sample

Result

City unit name contact address
bhopal mp nagar 8770761966 plot no 45 hoshangabad road bhopa
indore 56 dukan 3543657334 dukan no. 56 chappan road indore
 
Prayagraj sangam 4534563345  kuch bhi addrss sample 
Rewa maple 8775938587 lknav fni ample sample
Feb 10, 2023 in Power BI by Amit

edited 5 days ago 9 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP