Forum Discussion
anuradha01
Helper I
Helper ICombining Excel files on multiple sharepoint folders using Power BI
Hi All I have Excel sheets saved on multiple different sharepoint folders. They all have the same format but different data. I need to combine data from all the Excel sheets and generate some Po...
foodd
Community Champion
Community ChampionIf I may, my suggestion would be to shift your approach to change from Google Forms to Microsoft Forms which would store the data in Excel format. Once that is true, you can shift handling of Excel files using the following method which would be much easier.
Magically combine Excel files From SharePoint Folder with bonus debugging tip