Data Integration (Power BI)

Use the Data Integration process to extract data from a Prophix staging database and load it into a Power BI dataset. The process requires you to specify resources (Site, Connection, Source, ) that a Global Administrator sets up beforehand in the Prophix Data Integration Service.

The Power BI agent is a destination-only agent that enables you to load data from the Prophix Staging database (MySQL) into a Power BI dataset.

 Example:  You can export data from a Prophix Cube into the Staging database using a Process Manager export process, and then load this data to a Power BI dataset using the Power BI agent.

This process has the following parameters:

  • Description: Optional. Up to 250 characters.

  • Site: Select the site that you want to use.

  • Source

    • Connection: Select the MySQL connection that you want to use.

    • Query: Select the specific source query that you want to run.

  • Filters

    The Filters table lists parameters that you can use to filter the query. Accept the default values or provide your own.

     Tip: Hovering over a Value cell reveals its expected input/format.
  • Destination
    • Connection: Select a Power BI connection.

    • Group (workspace) name: Select a workspace.

      If your workspace does not appear in the list, this is because the application service principal does not have access to that workspace.

      To learn how to add the service principal to your workspace, refer to the Microsoft documentation.

      Select an option for loading the data into the Power BI datasets:

      • Create/Refresh: Select to do one of the following:

        • To create a new dataset and table to load with the source data, type their names in Dataset name and Table name.

        • To refresh the data in an existing dataset/table with new source data without having to delete and recreate the dataset/table, from Dataset name and Table name select the options existing_dataset and existing_table.

      • Append: Select to have the source data appended to the existing data in the dataset and table.

    • Dataset name: Select a dataset from the chosen workspace.

      (If your dataset does not appear, this is most likely because the dataset was not created by the Prophix data integration process.)

    • Table name: Select a table from the chosen dataset.

  • Logging

    • Verbose logging: Turn on to add extra debugging details to the Task Log.

How long the process runs

The Data Integration (Power BI) process does not have a time limit; it will run as long it needs to complete. However, it monitors the data integration agent running on the ERP server and if the agent stops running, the Data Integration process ends. The process is then marked as failed and will not restart. You can also cancel the process in the Task Log.