Forum Discussion
Solved
Power Query custom function to loop over multiple tables and do the required transformation
Hi Everyone, I have multiple tables (Around 10) in Power Query and I want to do some transformation to all the Tables. Say I want to add a custom column to all the tables. I want a custom func...
Yeah, no. You cannot inject transforms into queries from the outside. You need to do these transforms in each of the queries, or follow my approach and then use references.
Got it lbendlin . If I follow your approach, then I will have a list of tranformed tables or a table containing 3 rows, each row referencing to a tranformed table. Can I extract each table as seprate table?
Not in Power BI. Maybe in Excel. Maybe via the Graph API