web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Use Flows to Automate ...
Power Automate
Unanswered

Use Flows to Automate Add Row to Excel from Power BI Weekly

(0) ShareShare
ReportReport
Posted on by

Hello! 

 

I have been able to create successful manual flows by clicking a button powerbi > Excel, but I have not figured out how to automate that process so I can do it weekly or monthly. 

 

-NL

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @Anonymous 

    Have you tried to use the Recurrence trigger?

     

     

  • Community Power Platform Member Profile Picture
    on at

    @ScottShearer Thanks for the quick reply, the image is what I currently use. What I would love to be able to do is automate the export from PowerBi weekly. I have not found a way to add a recurrence to this flow, or create a flow that references the powerbi flow to add rows to the excel

     

    nm1087_1-1629483584209.png

     

     

  • ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @Anonymous 

    I don't see a straight forward way to meet your requirement - very interesting question.  

    There may be a back door method using Office scripts (in Excel) which can be called from a Flow.

     

     

     

     

  • Community Power Platform Member Profile Picture
    on at

    @ScottShearer  thanks for the info, I've never used those before. Any suggestions on where to start or resources you are familiar with?

  • ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    Intro to Office script for Excel.

     

     

  • Community Power Platform Member Profile Picture
    on at

    Thanks! I'll dive in

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard