Our modern Reporting API has replaced the older technology of the reporting database. The reporting database will no longer be available for existing systems that never activated the database nor for new test systems created since 09/10/2020.
The reporting database will remain active in existing systems that are currently using the feature. We are happy support you with any questions concerning the migration to the new Reporting API before replacing the reporting database. If you have any questions, please contact us at support@meisterplan.com.
This article describes, step by step, how to access Meisterplan reporting data with Microsoft Excel after activating external reporting in Meisterplan and setting up an ODBC connection (see the Preparations for Reporting with Microsoft Power BI or Microsoft Excel article for details).
Opening Microsoft Excel
- Open Microsoft Excel and create a Blank workbook.
Selecting the ODBC Data Source
- Open the Data tab.
- In the Get External Data section, open the From Other Sources menu and select the From Data Connection Wizard option.
- In the data connection wizard, select the ODBC DSN data source type and click Next.
- Select the Meisterplan data source you created and click Next.
Selecting Reporting Tables
- Select the reporting table to connect to and click Next.
- Click Finish.
- Select the desired display mode for displaying the data in Microsoft Excel.
- Repeat these steps for each reporting table you wish to import.