Combining Multiple Excel Documents from Sharepoint

Like (1) Share

Report

Posted on 15 Nov 2024 19:15:45 by BM-15111858-0

Hi. Let me start by explaining my goal: Having a Power BI dashboard that is easy for my team to use at a glance.

I have a SharePoint folder that gets a new excel file uploaded to it every day. I want to pull the data from this file and upload it to a "combined file". like this:

Daily Upload Files:

Combined Files:

My idea is that I can auto update BI using Power Automate whenever this combined file gets modified.

Is there a way to do this? or is there a better way to do this?

Categories:

Business Process Flows

All responses (1)

Answers (0)

lbendlin 7,753 Super User 2025 Season 1 on 15 Nov 2024 at 23:10:23

Like (1)

Report

Combining Multiple Excel Documents from Sharepoint

What do you need Power Automate for? Just combine the files in Power BI (Power Query) directly. Use the SharePoint Folder Connector.