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.
Hey Everyone!
I have a folder with over 200 files, all of which contain the same table, within the same format. Today I need to include an additional column. Can I do so without having to alter every file within the folder?
I would like to add a new file with the same format (+ 1 additional column) and for Power BI to register that there is a new column and alllow me to manipulate within my model. How can I do this?
Let me know, thanks!
Solved! Go to Solution.
Yes, send me PM..so we can check that.
Hi @AlexAlberga727 ,
You can add this new column to the end of the excel sheet.
So you would only check the data type in the Transformation File Sample. If you include it in the start/middle you will need to check the transformations applied.
Thanks for taking your time to reply.
I have checked the transformation files found within Power Query and am unable to locate an area where I could edit the transformation file.
Would you be willing to have a screen share?
Yes, send me PM..so we can check that.
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.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |