Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a source spreadsheet with three columns.
Column A contains a list of table names, Column B and C are mapping/conversion fields for those tables.
Example snipett:
e.g. Dimension table contains DimensionTitle field which is named "Title" on the system
My task is to create a conversion table to automatically rename those columns, however rather than do this manually for each table, I wondered if there's a way to use the values in Column A to automatically convert the spreadsheet into as many tables as there are unique values?
Solved! Go to Solution.
You cannot dynamically add queries in Power Query.
You cannot dynamically add queries in Power Query.
I suspected so but thanks for confirming!
Hi, @Anonymous ;
Try to create a new table by dax.
new =
VALUES ( 'table'[column] )
Or
new =
SUMMARIZE ( 'table', [column1], [column2] )
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi there thanks for your reply. Unfortunately I need to do this in power query not in the data model. I will resort to some VBA to split out the excel table into multiple tabs instead.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.