Get excel file from multiple folder on sharepoint folder

[Shuuuu]

Hi, I need to get data from sharepoint folder. There is three folder with different data of excel files. But the column header are the same. Is there any way to get it automatically other than manually get the data one by one ? 

[v-xiaotang · Accepted solution]

Hi @Shuuuu 

Thanks for reaching out to us.

Please check if this article helps, 

Solved: How to get data from multiple folder - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

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

[ibarrau]

Hi. There are different ways to connect to sharepoint. You have already built in the PowerBi Desktop to check the connectors. You can also check this post to have an alternative:
https://blog.ladataweb.com.ar/post/627427136962281472/powerbi-obtener-datos-de-una-carpeta-de

I hope that helps,