Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
PowerBI5
New Member

Power Automate to Power Bi

‎12-10-2023 11:53 PM

Hi all,

 

I have a sharepoint folder which consist a list of excels. Currently the Power Automate will refresh when this particular "XXX" excel data has been edited. However, i want to improve the flow even more.

Is it possible when a new excel data is inserted into folder. for example today is 11/12. The file name will be "XXX 11/12". I want power BI to take this excel data and update accordingly using Power Automate.

 

If today is 12/12, the person who insert the excel into sharepoint will have the excel name as "XXX 12/12" and i want power BI to use this folder now.

 

Please assist thank you!

Labels:
Message 1 of 3
274 Views
0
2 REPLIES 2
christinepayton
Super User
Super User

‎12-12-2023 08:29 AM

You can create a Power Automate flow that triggers "when a file is created", give it your folder path, then add the action for "refresh a Power BI dataset" and select your dataset. It's generally more common to just schedule the refresh though. 

Message 3 of 3
213 Views
0
aj1973
Community Champion
Community Champion

‎12-11-2023 10:16 AM

Hi @PowerBI5 

I recommend you use Dataflow and Combine Folder(It will append files automatically). Use the Dataflow for your Power Automate

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Message 2 of 3
240 Views
0

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

View All