Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
"You can't dynamically ... in Power BI/Query"
I'm coming from Qlikview/Sense universe and finding many answers like that...
So I'm thinking that Qlik isn't too bad as I used to say
Wait until you try to create dynamic buckets 🙂
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |