Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful Individual
7 years ago

PowerQuery | Sharepoint & Excel with Multiple Tabs

First time attempt but I used to do this on a local directory and is working fine using File.Contents however this technique doesn't seem to work in Sharepoint because it's asking for a "valid absolu...
Need Help
  • ovetteabejuela's avatar
    ovetteabejuela
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    Hi v-cherch-msft,

     

    Thanks but I think what this shows is how to load stuff from OneDrive which I really don;t have a problem with. The problem that I'm facing is:

     

    How to load(merge) multiple tabs from an excel file while it is on one drive, the thing is I am able to do this given that the file is on a local drive. I was mainly using a function called "File.Contents" where it is only accepting absolute path, now that the files are in OneDrive I don't have the absolute path anymore and thus is an invalid parameter for File.Contents() function. I can't sync the OneDrive library -it will defeat the purpose of placing them in OneDrive.

     

    So again, how would someone load/merge multiple tabs from multiple excel files given that they are in OneDrive? I hope someone could show me, tried researching on this but nothing relevant pops up.