Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Approvals Power Automate + Power BI

hellow everyone,
My first publish that great community, so...

I have a flow in power automate that uses the 'Approvals' application, I would like to consume the data from these approvals in power bi, do you know if it is possible and how should I connect?

I already appreciate a lot of help!

 

 

i have account Pro and WorkSpace premium per user.

  • The way I've done it in the past is to store the Approval data (Approval status, date, submitter, approver...) somewhere then use that destination as the source for Power BI. You may use an Excel table, a SharePoint list, Dataverse for Teams, Dataverse from PowerApps, SQL Server... it depends on how much data you're going to generate and what you're most comfortable using.

2 Replies

  • otravers's avatar
    otravers
    Community Champion

    The way I've done it in the past is to store the Approval data (Approval status, date, submitter, approver...) somewhere then use that destination as the source for Power BI. You may use an Excel table, a SharePoint list, Dataverse for Teams, Dataverse from PowerApps, SQL Server... it depends on how much data you're going to generate and what you're most comfortable using.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks !!! i will try to do it ğŸ˜‹