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?
What do you need Power Automate for? Just combine the files in Power BI (Power Query) directly. Use the SharePoint Folder Connector.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
