Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have an Excel file with multiple sheets using the same structure that I need to append togeter in M.
Each month there is a new sheet added to the file so I need to develop a script able to append all sheets in the file without hardcoding anything.
I have been able (via some Googling) to combine workbooks and Excel tables, however I haven't been able to append sheets that aren't defined as Excel tables.
Any help would be greatly apprecited.
Solved! Go to Solution.
The following post covers the solution: https://community.powerbi.com/t5/Desktop/Multiple-sheets-with-the-same-format/td-p/88899
TL;DR Create an M function that cleans up a sheet (promotes headers, etc.), and then add a custom column using the function, which you can then expand to get all your data combined.
Can provide additional guidance if you're still stuck on something.
The following post covers the solution: https://community.powerbi.com/t5/Desktop/Multiple-sheets-with-the-same-format/td-p/88899
TL;DR Create an M function that cleans up a sheet (promotes headers, etc.), and then add a custom column using the function, which you can then expand to get all your data combined.
Can provide additional guidance if you're still stuck on something.
Thanks for that Mark.
I've actually read that article but couldn't make it work as I missed one little detail which I have now noticed following your post.
Thanks
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |