Forum Discussion
Load multiple sheets from multiple excel files
Hi, I am new to M programming. I am trying to load multiple sheets from multiple excel files into PowerBI but I couldn't get it to work. I want to use a parameter to pass in a folder locatio...
Hey Anonymous , I've attempted the solution from your link. And it will only M code-work one file in the folder. Leaving all the other as blank entries.
Have you encountered this issue? Think you could lend me a hand?
Particularly I have about 15 files, each with 3 tabs each. I want to merge the files by tab (they are all named the same).
Thanks!
Hi Anonymous
Sorry for my late reply.
No. I did not encounter such difficulty.
But perhaps if you share your M code the community and I could help you to find a solution.
Best regards. G.