Export to Excel and Power BI for Microsoft Dynamics 365 Business Central
Quality data is only useful if someone can analyze it. When values are trapped in forms, building a supplier scorecard or a defect summary means retyping results into a spreadsheet.
Quality Inspector lists test values in a form that suits analysis. Group and pivot them in Business Central analysis views, or export them to Excel, Power BI, and other tools.
How Export to Excel and Power BI works in Quality Inspector
- Inspectors record and finish tests.
- Open the test values list.
- Group, filter, or pivot the values in an analysis view.
- Export to Excel, or connect Power BI, for further analysis.
- Share the results with the people who need them.
Key capabilities
Test values list
One list holds the test values across tests, with test number, field code, value, and grade.
Analysis views
Use standard Business Central analysis views to group values by grade, filter, and pivot without leaving Business Central.
Excel
Export the list to Excel for ad hoc analysis or to share with people outside Business Central.
Power BI and other tools
Use the values in Power BI and other reporting tools, alongside the rest of your Business Central data.
Report layouts you can change
Reports are kept simple so you can customize the layouts, and the default Word layout can print multiple tests in one report.
See Export to Excel and Power BI on screen
Real screens from Quality Inspector, shown with demo data.
Details that matter on the floor
The data is native
Values are Business Central data tied to the lot, item, and document, so analysis does not start with a reconciliation.
Simple by design
Quality Inspector keeps its reporting straightforward and leaves dashboards to the tools you already use.
Who uses Export to Excel and Power BI
Data analysts
Build quality reports from structured test values.
Quality assurance managers
Review results by grade, item, or supplier.
Process improvement specialists
Look for patterns across many tests.
Questions about Export to Excel and Power BI
Can I export quality inspection results from Business Central to Excel?
Yes, with Quality Inspector. Test values are listed for analysis views and can be exported to Excel, Power BI, and other tools.
Does Quality Inspector include dashboards?
Reporting in Quality Inspector is kept simple. Use analysis views in Business Central, or Power BI and Excel, for dashboards and summaries.
Can I group results by grade?
Yes. Analysis views can group test values by grade, then filter or pivot them.
Related Quality Inspector features
All Quality Inspector features →Part of Quality Inspector
Streamline your quality control process to reduce rework and maximize customer satisfaction.
Have a question about Export to Excel and Power BI?
Send us a note and the Quality Inspector team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
