Forum Discussion
Advocate Icombine multiple excel files have different header into one
Instead of creating multiple queries and append subsequently, it would be easiest to store all your files in one folder and then use the Import from folder method. But instead of using Binary combine, write your own custom function that unpivots first, before combining all results from the different sources.
Check these sources on how to write your own function:
https://blog.crossjoin.co.uk/2016/05/15/creating-m-functions-from-parameterised-queries-in-power-bi/
Community ChampionInstead of creating multiple queries and append subsequently, it would be easiest to store all your files in one folder and then use the Import from folder method. But instead of using Binary combine, write your own custom function that unpivots first, before combining all results from the different sources.
Check these sources on how to write your own function:
https://blog.crossjoin.co.uk/2016/05/15/creating-m-functions-from-parameterised-queries-in-power-bi/
Advocate IThank you very much, actually my files are in the Sharepoint Online folders but I found a solution from the linked pages.
Cheers!