Forum Discussion

sabedin's avatar
sabedin
Icon for Helper I rankHelper 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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

It is doable, does the files have more than one sheet or just always one sheet and sheet names are different?

sabedin's avatar
sabedin
Icon for Helper I rankHelper I
8 years ago

Only one sheet

 

Thanks

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    ok i have a solution just created, will share with you, it will read all the excel files from a folder and all the sheets frm a file (even if there are more than one). you can change stuff as you want.

     

     

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      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
        Icon for Helper I rankHelper 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