Forum Discussion
Upload files from Sharepoint using Power Automate
Hi all,
This is my first time using Power Automate and have been given the task of appending a number of files in a sharepoint folder so that they can create a dataset within Power BI, with the possibility of this being updated on a monthly basis when a new file is dropped in.
Any help on this would be much appreciated.
Thanks
Alex
Hii Anonymous
You don’t need Power Automate to append files manually.
Power BI can automatically combine all files inside a SharePoint folder and refresh whenever a new file is added.Use “SharePoint Folder” connector in Power BI
- In Power BI Desktop >> Get Data >> SharePoint Folder
- Paste your SharePoint site URL (not the folder URL)
- Power BI will list all files >> filter to your folder
- Use Combine & Transform
- Publish to Power BI Service
- Set up scheduled refresh
Now, every time a new file is dropped into the SharePoint folder, Power BI automatically appends it to your dataset.
Below link help you to achieve your solution :
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder?
6 Replies
Hii Anonymous
You don’t need Power Automate to append files manually.
Power BI can automatically combine all files inside a SharePoint folder and refresh whenever a new file is added.Use “SharePoint Folder” connector in Power BI
- In Power BI Desktop >> Get Data >> SharePoint Folder
- Paste your SharePoint site URL (not the folder URL)
- Power BI will list all files >> filter to your folder
- Use Combine & Transform
- Publish to Power BI Service
- Set up scheduled refresh
Now, every time a new file is dropped into the SharePoint folder, Power BI automatically appends it to your dataset.
Below link help you to achieve your solution :
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder?
Hello Anonymous,
Welcome here and Power Automate World!
Steps in Power Automate
- Trigger:
- Connector: SharePoint
- Action: “When a file is created in a folder”
- Configure the correct folder path.
- Action:
- Connector: Power BI
- Action: “Refresh a dataset”
- Select the Workspace and Dataset.
Check this document from Nikhil Gaekwad:
Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BIand then check this topic to reference:
Solved: Refresh Power BI Dataset using Power Automate - Microsoft Fabric Community
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Anonymous , Power BI, we have a direct connector for SharePoint. any reason you want Power Automate?
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folderor
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Anonymous , we can do that using
https://exceleratorbi.com.au/load-the-latest-version-of-a-file-in-power-query/
Sort on datetime, take 1st row always
