Introduction #

In this section we describe connectivity between Power BI and Xtract Universal through Xtract Universal’s Power BI Connector destination.

The Power BI Connector destination offers two ways for connecting Power BI to Xtract Universal:

  1. Power BI custom connector
  2. Generic Power Query M-script

Power BI custom connector and Power Query M-script #

The Power BI custom connector will add an Xtract Universal data source to Power BI’s list of data connectors. This allows convenient and guided selection of Xtract Universal extractions from within Power BI.

In addition to this custom connector, we deliver a Power Query M-script for those scenarios where the use of a custom connector is not possible or supported.

In both cases Xtract Universal extractions will be triggered from Power BI and extracted data will be directly loaded into Power BI for further processing.

Supported Power BI environments #

The Xtract Universal Power BI custom connector supports Power BI Desktop and the Power BI service (through Power BI on-premises data gateway). In addition to these environments, the Xtract Universal Power Query M-script supports the Power BI Report Server.

  Custom Connector M-script
Power BI Desktop X X
Power BI service X X
Power BI Report Server - X

Power-BI-Connector-

Connection

Settings

Power BI Custom Connector

Power Query M-script

Power BI service

Single Sign On and SAP authentication

XU Custom Parameters in PBI

Troubleshooting