Forum Discussion

leonghio's avatar
leonghio
Frequent Visitor
8 years ago

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...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.