Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Auto-Import Data from sharepoint Attachments to Excel using Power Query

hi All in sharepoint folder  i have two groups  Marine Lubricant folder1 (excel file) group1 (excel file) folder 2 (excel file) group2 (excel file)   group 3 (excel file)   ev...
Need Help
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi Anonymous,

    We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

     

    danextian, vojtechsima   Thanks for your prompt response

     

     


    Thanks,

    Prashanth Are

    MS Fabric community support

Anonymous's avatar
Anonymous
Not applicable
1 year ago

can you give the M-query and provide any sample file of .pbix

 

Regards

 

 

  • danextian's avatar
    danextian
    Super User
    1 year ago

    That’s hard to provide without knowing the structure of your Excel files — we don’t have a sample. What should be done with each group? Which sheets should be used? Which columns? Does the data always start in the first row, and is that consistent across all files?

     

    I've blogged about connecting to connecting to multiple worksheets across multiple workbooks and folders. This uses the Folder connector which doens't have the extra steps priot to combining the files had the Sharepoint connector been used. - https://youtu.be/vFBk-_FDFh0