Forum Discussion

sabedin's avatar
sabedin
Helper I
8 years ago
Solved

Loading data from folder, different sheet names

Hello,   I have Excel files with data in same format, but the sheet names in the files are different. This brings an error "the key didn't match any rows in the table” when loading the files.    ...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    8 years ago

    here is link to pbix file , it has two functions, read sheets from excel files and then read data from each sheet in excel file.

     

    feel free to reach out if you need further help./

    https://drive.google.com/file/d/0B4dPgH9_BPBraFhtTVdnd05OSnM/view?usp=sharing
sabedin's avatar
sabedin
Helper I
8 years ago

Thanks for this, I tried but no luck... I tried to match parameters, but it seems that this is too complicated for me.

 

Did you check the link I posted? It seems to be an easier solution to this?!

 

Thanks

Sabedin

parry2k's avatar
parry2k
Super User
8 years ago
You don't need to do anything with parameters.


That is for internal stuff. You just need to give path where your files are and rest will work.
  • sabedin's avatar
    sabedin
    Helper I
    8 years ago

    Hello,

     

    I had to delete the last step, because it was requiring column from your files, and it seems to work now :)

     

    Thanks a lot again Sir.

    Sabedin

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      sabedin

       

      Glad to hear, sorry I missed to mention that but you got it. cheers

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi! 

        I'm still a novice at Power BI, but I'm trying to figure out how to properly use your functions. Am I supposed to copy and paste the M language in the Advanced Editor for each function into my own PBIX file where my data is at? And then from there, once it's been set up, what are my next steps?

        Similar to the person who posted this question, I have several excel files where the format is the same (Profit Loss statements), but each tab represents a different entity for the P-L. I'm trying my best to transform them, but my prior attempts don't go anywhere. I'm curious to see if your solution works, but I don't know how to use your functions. I'd so appreciate a walk-through step-by-step, especially since I've been using Power Bi for only two weeks :)

        Thanks!