Get Data > SharePoint Folder - Combining issue

[selpaqm]

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? 

[dax · Accepted solution]

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.