Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Interface between Power BI & Power App

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?