Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I am looking for a functionality in Power BI where I can externally map the multiple attributes to staging table attributes. There are multiple data sources with different structure and attribute names that needs to be added in one table. One way to do that is SSIS and connect the staging table to PowerBI directly. Is there any other way to map attributes in PowerBI directly ?
Solved! Go to Solution.
@varunaggarwal30,
You can use DAX to create a new table, there is an example for your reference.
NewTable = UNION(SELECTCOLUMNS(Stage,"col1",Stage[Column1],"col2",Stage[Column2],"col3",Stage[Column3]),SELECTCOLUMNS(sheet1,"col1",sheet1[Alias],"col2",sheet1[Column3],"col3",sheet1[id]),SELECTCOLUMNS(Report,"col1",Report[name],"col2",Report[Column10],"col3",Report[column1]))
Regards,
Lydia
@varunaggarwal30,
You can use DAX to create a new table, there is an example for your reference.
NewTable = UNION(SELECTCOLUMNS(Stage,"col1",Stage[Column1],"col2",Stage[Column2],"col3",Stage[Column3]),SELECTCOLUMNS(sheet1,"col1",sheet1[Alias],"col2",sheet1[Column3],"col3",sheet1[id]),SELECTCOLUMNS(Report,"col1",Report[name],"col2",Report[Column10],"col3",Report[column1]))
Regards,
Lydia
@Anonymous,
Is there any way we can have different column numbers and can add new columns from different sources. I tried add column option but it says union should have sam column
For Workaround I gave same columns in the all tables and kept them empty for non source table. Is there any cleaner way to do this?
@varunaggarwal30,
When using Union function, column number should be same from different tables.
Regards,
Lydia
@Anonymous Thanks!!!. I guess it should work..
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 53 | |
| 52 | |
| 39 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 94 | |
| 81 | |
| 34 | |
| 29 | |
| 25 |