Forum Discussion

selpaqm's avatar
selpaqm
Helper V
6 years ago
Solved

Get Data > SharePoint Folder - Combining issue

Hi All,

 

I want to move my local folder to sharepoint as located https://mycompany.sharepoint.com/sites/MySite/shared%20documents/Forms... I know that to use root folder which is my site "https://mycompany.sharepoint.com/sites/MySite" there is no problem at this stage Power bi adds "ALL" excel files and combine thme. however I do not want to combine all files inside MySite.

I want to combine all files under specific folder. like https://mycompany.sharepoint.com/sites/MySite/MyFolder

Do you have any idea? 

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi selpaqm , 

    When you use sharepoint folder connector, it will show all files in site, so if you want to show  corresponding folder, I think you need to set filter based on folder path like below

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi selpaqm , 

    When you use sharepoint folder connector, it will show all files in site, so if you want to show  corresponding folder, I think you need to set filter based on folder path like below

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.