Request sign-off flow to PowerBI

Like (0) Share

Report

Posted on 6 Apr 2020 16:46:15 by annetoal

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

All responses (2)

Answers (1)

annetoal 1,934 Moderator on 09 Apr 2020 at 15:10:20

Like (0)

Report

Re: Request sign-off flow to PowerBI

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

Anne
Verified answer

JohnAageAnderse 1,986 on 09 Apr 2020 at 14:41:11

Like (0)

Report

Re: Request sign-off flow to PowerBI

Hello @annetoal
Is this what you are trying to do?
Before 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