Forum Discussion

imenmaiza's avatar
imenmaiza
Helper II
3 years ago

Manufacturing Execution Systems (MES) data extraction

Hello, I have some questions and I need help, I I would like to extract data from Manufacturing Execution Systems (MES) more specifically from MES system called "cosrewis" How is this possible ...
"Power BI Report Server"
Data extraction
Anonymous's avatar
Anonymous
Not applicable
1 year ago

To extract data from a Manufacturing Execution System (MES) like Cosrewis into Power BI, you will typically follow these steps:

  1. Identify Data Source: First, you need to understand how Cosrewis exposes its data. If it provides an API (REST or SOAP), you can connect Power BI to it using a custom connector. If Cosrewis supports direct database access (SQL, for example), you can connect Power BI directly to the database.

  2. Establish Connection in Power BI:

    • For API-based Integration: You can use Power BI’s built-in connectors or write custom queries using M code (Power Query). If Cosrewis provides an API, you can call it from Power BI using the Web connector. To do this:
      • Go to Power BI Desktop → Get Data → Web.
      • Provide the API URL and authentication details.
      • Use Power Query to extract and transform the data into the format you need.
    • For SQL Database Integration:
      • Power BI can connect directly to a SQL database (if Cosrewis uses SQL as its backend). Go to Power BI Desktop → Get Data → SQL Server and enter the connection details. Once connected, you can use SQL queries or Power Query to retrieve data.

  3. Transform Data in Power Query: After connecting to the data source, you can clean, transform, and filter the data using Power Query. Power BI’s query editor allows you to modify the data as needed before loading it into the model.

  4. Create Data Model & Visualizations: Once the data is in Power BI, you can create your data model, relationships between tables (if necessary), and visualizations. Use Power BI’s built-in visuals to display manufacturing insights, such as production data, downtime, throughput, etc.

  5. Deploy on Power BI Report Server: Since you are planning to deploy the report on Power BI Report Server, you need to ensure that:

    • The Power BI report is published to the Report Server.
    • Data refresh is configured correctly (whether it's on-demand or scheduled).
    • The server has the required permissions to access the data source.

Here’s the blog you can refer to for a deeper dive into MES software integration with Power BI.