I'd be very grateful if someone could support me with this case. I'm new to this world.
I need to create a master table so I can relate to all the different tables.
I have many Excel files that I have loaded into Power BI. When I try to accumulate the IDs in one column, Excel explodes because it is so much information.
I want to do this process in PBI, where I can select the ID columns of each table and accumulate them in the master and then relate them.
I tried Merge Query and got different columns. I need it all in one column.
I also used Union but it tells me that it needs unique fields and that is what I want to create.
Thanks in advance for the support,
Garys JavierDominican Republic
To create relationships in Power BI, you can take a look at this document.
If it doesn't meet your requirements, please provide some sample data and clarify corresponding results.
Best Regards,Qiuyun Yu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.