Power Apps (Dataverse)
by Microsoft
Model-driven Power Apps and many canvas apps store their data in Dataverse, which the Web API exposes as tables and rows, along with solutions, users with their business units, and audit history of who changed which record. Copied into your Lake, those custom tables stop being isolated app data and join ERP, HR and finance records, while the audit trail shows how the apps are actually used.
- Category
- Developer Tools
- Type
- Low-code
- Interface
- OData API
- Built with
- Connect Any API
- Credentials
- OAuth 2.0, Service account key
02Data
What you can sync.
- Tables
- Rows
- Solutions
- Users
- Audit history
Join Power Apps (Dataverse) tables with product usage and revenue to see what each release changed.
Need more? Name any other Power Apps (Dataverse) data the API returns, and the AI adds it to the connector.
03Credentials
Credentials you will need.
- OAuth 2.0 (client ID, client secret, refresh token)
- A service account key
Power Apps (Dataverse) uses OAuth 2.0 (client ID, client secret, refresh token) or a service account key. You add the credentials once, when the AI asks for them, and it tells you where to create them in Microsoft if you need help.
04Questions
Questions you can answer.
Once Power Apps (Dataverse) data is in your Lake, ask an AI Mind in plain words or build the answer in DataPrism BI.
- Which custom tables added more rows this quarter than last, and which have had no new rows in six months?
- Who changed the status or owner of records in our approval table last month, according to audit history?
- Which solutions were imported into production, and which version runs in each environment?
- How many active users does each business unit have, and which users have not modified a record in 90 days?
- How long do requests captured in our apps take to move from submitted to approved?
05How it works
How it works in DataMind.
-
Pick Power Apps (Dataverse).
Open Lake, pick Power Apps (Dataverse) in the source picker and name the connection. Connect Any API opens with a ready prompt that points the AI at the Power Apps (Dataverse) API docs.
-
Answer a few questions.
The AI reads the Power Apps (Dataverse) documentation, then asks which credentials you will use, which data to sync (for example tables and rows), whether you want a one-time load or a recurring sync, and which accounts or filters apply.
-
Your data lands in Lake.
It builds the connector, tests it and shows you sample rows. Then Power Apps (Dataverse) data loads into your Lake on your schedule, ready for the Warehouse, DataPrism BI and AI Minds.
06Pairs
Works well with Power Apps (Dataverse).
Sources teams join with Power Apps (Dataverse) in the Warehouse, each one connected the same way.
07Related
