Interface between Power BI & Power App

[Syndicate_Admin]

Hello!  My department has been using Power BI to identify anomalies in transactions (from a large ERP) that other groups and we need to research.  We want to create a Power App interface/workflow for all of us to track follow-up & perform a root cause analysis on these anomalies.  We are not technically sophisticated, but Power Query & Power Apps have been in our abilities.  Because of the large number of users, we are limited to the basic version of Power Apps that I believe only allows either Excel or a SharePoint list as a backend.  Basically, the Power App back-end should be one record for each unusual transaction with a number of fields from the Power BI analysis (Transaction ID, Location, Customer, Transaction Date, $ Amount) and 3 user-populated fields (Status of Research, Root Cause Bucket, Comment).  How do we get the unusual transactions identified by the Power BI analytic into the Power App backend?  

[v-stephen-msft]

Hi @eb11818,

I think you want to understand the integration of Power BI and Power Apps, you can refer to

https://www.epcgroup.net/power-bi-integration-with-powerapps/

Set up Power BI integration - Power Apps | Microsoft Docs

Power BI integration with Power Apps

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.