To use the Marini Systems DataEngine with Power BI, follow these steps to install the required Power Query Connector:
- Download the connector file: Get the .mez file for the Marini DataEngine via this link. Please note that Marini Systems takes no liability for this Microsoft connector and the downloaded file.
- Place the connector file: Save the downloaded .mez file in the following location on your computer. If necessary, create the following path:
C:\\Users\[YOURUSER]\[Documents]\Microsoft Power BI Desktop\Custom Connectors - Enable custom connectors: Ensure that Power BI allows the use of third-party custom connectors. You can find detailed instructions at this link.
- Restart Power BI: Close Power BI and reopen it to load the newly added connector.
Alternatively, we can provide a signed power connector upon request. This may be needed if, for example, the connector needs to be deployed automatically within a company without each user having to perform the above steps.
Make data available in Power BI
Make sure you have a Client ID and Client Secret to access your instance’s API. If not, please visit the page Generate new client credentials.
Follow these steps to import data from the Marini DataEngine into Power BI:
- Go to “Get Data”: Open Power BI and navigate to the “Get Data” dialog.
- Search for Marini DataEngine: Enter “Marini DataEngine” in the search bar to find the connector.
- Connect to the custom connector: Select “Marini DataEngine – Data Objects (Beta) (Custom)” to retrieve the available data objects, then click “Connect.”
- Enter the Instance Identifier: Enter your instance identifier (e.g., “your-instance.marini.system”) when prompted.
- Provide Client ID and Client Secret: Obtain these values from your DataEngine administrator and enter them when prompted.
- Select the data to load: After authentication, a window will display the available data objects. Check the boxes next to the data objects you wish to use in Power BI and confirm your selection by clicking “Load.”
General Information
- Data load time: Importing data into Power BI can take some time, depending on the number of fields and records in a data object.
- Additional setup information: More details about setting up the Client ID and Client Secret can be found in our Help Center.
- Power Connector for Mac: You can also use PowerBi on Mac by installing a Windows simulator first.
If you need further assistance, contact our support team or check our Help Center.
Remember that your data holds power – visualize it seamlessly now with the Marini DataEngine and Power BI!