Microsoft Power BI v2

Warning

Microsoft will retire the capability that Dataiku is using to publish datasets on Power BI on October 31st, 2027.

Should you experience any restrictions with the Power BI API prior to this date, please submit a support ticket through Microsoft’s platform. You can find instructions on how to do so here.

Further details are available on the Microsoft Power BI Blog (the comment section is not visible with all browsers and requires to accept cookies) and Microsoft Learn.

Microsoft Power BI is a cloud-based business analytics service that gives you a single view of your most critical business data.

This capability is provided by the Microsoft Power BI v2 plugin, which you need to install. Please see Installing plugins.

Microsoft Power BI and Dataiku are 2 complementary solutions. In a typical usage scenario, users will be able to:

  • build workflows in Dataiku to create complex data transformation pipelines and build machine learning models, possibly relying on other Microsoft technologies (such as Azure Blob Storage, Azure Data Lake Store, Azure HDInsight or SQL Server).

  • then push the output of these workflows directly to Power BI to be consumed by end users, using its interactive visualization and dashboarding features.

The Power BI custom exporter can be used directly from the Export menu of the Dataset, or through an Export Recipe. If the latter is used, it will be usable in a Dataiku Scenario and the data can be refreshed automatically on a schedule.

Obtaining Valid Power BI Credentials

The capability uses the Power BI REST API to interact with Power BI.

When using the Credentials authentication method, you need:

  • the username (email address) of the user authorized to access Power BI.

  • the associated password.

  • the client ID of the Power BI client application.

  • the associated client secret.

You also need to register a client application with the required permissions. The Azure interface may differ over time, but the main steps are:

  • (optional) In Microsoft Entra ID (Azure AD), create a dedicated service account for Power BI.

  • Register an application and note the client ID and client secret.

  • In API permissions, add Power BI Service dataset permissions and grant admin consent if required.

  • Configure the redirect URI as https://<<your Dataiku host>>/dip/api/oauth2-callback.

Refer to the official Microsoft documentation for details:

How To Use

This capability provides a Dataiku Exporter to export a Dataiku Dataset to Power BI. This exporter supports two authentication methods:

  • Microsoft Single Sign On (preferred method to get access).

  • User Power BI credentials, generating a new access token at each build.

Exporting a Dataiku Dataset to Power BI

The exporter will appear through the regular Export facility of Dataiku. For one-off export, just click on the Export function of a Dataset, and under “OTHER (CUSTOM)”, you will be able to see the custom Power BI exporter.

By default, the data will be exported into “My Workspace”. Power BI Pro license holders can export to any other workspace by adding its name in the workspace field.

To automate the export to Power BI, an Export to folder recipe can be used (you need to create an empty folder that acts as the output folder of the export recipe). The exporter will also be available there, will be part of the Flow, and can then be automated via Scenarios.

Using Dataiku data in Power BI

Once the export has completed, the data will be available for consumption in Power BI. The table associated with the dataset is called “dss-data”, and the data types will be inferred from the Dataiku Dataset. Visualizations can be built from there.