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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Request sign-off flow ...
Power Automate
Answered

Request sign-off flow to PowerBI

(0) ShareShare
ReportReport
Posted on by 1,934 Moderator

Hi, I am using a Request sign-off Flow template, modified at the end to push the results to a streaming dataset in PowerBI. It sends the names of the requester and approver, the name of the file, and the time approval was requested and when it was approved. It also sends Approve/reject status. The data is pushed to the streaming dataset after the Flow completes.

 

Now I have a requirement to show in PowerBI when a file has been requested for approval, but approval has not happened yet. Sort of "Pending" status. I tried putting another PowerBI push rows connector earlier in the flow, right after the request is made but before it is sent to the approver. Testing the Flow, it is not pushing the data to PowerBI on the "pending" connector. The final connector is still working properly, sending everything after the end of the Flow.

 

Please advise--what is the best approach to get a "pending" row in the streaming dataset?

 

Thank you,

Anne

Categories:
I have the same question (0)
  • Verified answer
    JohnAageAnderse Profile Picture
    1,986 on at

    Hello @annetoal 

    Is this what you are trying to do?

    Flow.PowerBI.BeforeAndAfter.pngBefore the approval, push a row with pending information to Power BI dataset.

    Do the approval

    After the approval, push a row with the outcome information to Power BI dataset.

     

    What goes wrong for you?

    Kind regards, John

  • annetoal Profile Picture
    1,934 Moderator on at

    I was putting the PowerBI connector too early in the process. When I put it where you suggested, it worked. Thank you!

     

    Anne

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard