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
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

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