Mar 31 2022 04:47 AM
I have case where I have a sharepoint site where multiple excel files are located as attachments. These files are put in on a regular basis.
I want to pull in data from all these excel files located in sharepoint and combine them into a single excel file on my local machine. How can I achieve that? Is there a way we can do this?
Apr 12 2022 04:23 AM
@dmeno245 This might be a solution for you: Combining Excel Files hosted on a SharePoint folder with Power BI | Blog rozwiązania Microsoft Power...