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