M‑Files has helped organizations organize, govern, and automate content for over 20 years. Its metadata‑driven workflows and clean UI (desktop, web, mobile) streamline everyday work—but when you’re facing thousands of documents, KPIs aren’t obvious at a glance. Decision‑makers want a single view of performance. Fortunately, M‑Files can export vault data to SQL Server, making it easy to unlock Power BI dashboards from your institutional knowledge.
Suppose your M‑Files vault has Deals with a workflow from inception to close, each Deal linked to a Product and a Company. What does your pipeline look like? How many deals are stuck in Pre‑Sales, and for which products? These are the questions sales leaders and executives ask—now you can answer them quickly. We will show you how!
In M‑Files Admin, open Reporting and Data Export underneath the vault you want to export data from. Create a dataset by choosing the objects (e.g., Deals, Products, Companies) and properties (e.g., Workflow State, Deal Amount, Deal Date, Related Company, Related Products) you need for reporting.
Next, set the SQL Server connection (server, database, credentials) and a schedule on the Advanced tab. M‑Files creates tables during export, so the SQL login must have permissions to create and write to tables.
In Power BI, connect via Home → Get Data → SQL Server.
After connecting, you’ll see tables for each exported object plus any multi‑select relationship tables. Select the relevant object and relationship tables and click Load.
Power BI usually detects relationships automatically. If filtering seems off, open Modeling → Manage Relationships and confirm the links.
With data ready, build your first visual: Deals by Workflow State. Use the Deal table’s State_ID (Count of) as Values and the State table’s Name as Legend to show distribution by stage.
You can also break down deals by state and product to answer, “Which products appear most in closed deals?” or “Which products dominate stalled Pre‑Sales?”
For Closed deals: place the relationship table’s Deal_Product(s)_Product as Values (Count of) and Product → Name or title as Legend. Add a filter where State = “6. Deal Closed” to get a clean product mix.
For stalled Pre‑Sales: again use Deal_Product(s)_Product (Count of) with Product → Name or title as Legend. Filter to State = “1. Pre‑Sales” and Deal Date is before 30 days ago to spotlight products in aging deals.
M‑Files + Power BI is a fast path to clear, executive‑ready reporting. If your processes live in M‑Files metadata, modern dashboards are only a few steps away. Contact TEAM IM to get started.