Manufacturing Execution Systems (MES) data extraction

[imenmaiza]

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 in Power BI?

The report will be deployed in Power BI report server.

Thanks a lot in advance for your help.

[Poojara_D12]

Hi @imenmaiza 

To extract data from your Manufacturing Execution System (MES), specifically the "cosrewis" MES, and use it in Power BI for reporting on Power BI Report Server, you would first need to establish a connection between Power BI and the MES system. Depending on how the "cosrewis" MES exposes its data, there are several methods you could use. If the MES provides an API (such as RESTful API) or a database (e.g., SQL Server, MySQL), Power BI can connect directly to those sources. For an API, you can use Power BI's Web connector to send requests and retrieve the data. If the MES data is stored in a relational database, you can use Power BI's built-in connectors (like SQL Server, OLE DB, or ODBC) to directly query and import the data. Once you connect Power BI to the MES system, you can transform and model the data using Power Query and DAX, create the desired visualizations, and publish the report to Power BI Report Server for sharing and access by users. It’s essential to check if your MES system supports integration with Power BI or third-party data connectors and ensure proper authentication methods are in place for secure access.

[tancha]

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.