Manufacturing Execution Systems (MES) data extraction

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.