In the M-Files Admin tool, an Administrator can setup a scheduled or one-time export for various datasets. This is extremely customizable.
The Admin can select the appropriate data points and relationships and export them to a defined, target database. In this example, the data is being exported to a MS SQL Database. This same database is then used as the Data Source within Power BI to create customized visualizations and dashboards.
Here is where Power BI can come in and provide insights on processes that are streamlined and automated with M-Files. In this example, the process that has been automated is for Purchase Order Approvals. By using the data exported from M-Files, Power BI can dynamically group Purchase Order documents within the M-Files Approval Workflow and the Workflow State in which the Purchase Order is currently in.
Data in M-Files and MS SQL Database