Microsoft Power BI is a cloud-based business analytics service that gives you a single view of your most critical business data.
This DSS Plugin offers the ability to export Dataiku DSS data to Power BI, using the regular Export infrastructure.
Microsoft Power BI and Dataiku DSS are 2 complementary solutions. In a typical usage scenario, users will be able to:
Export your DSS Datasets to Power BI.
|License||Apache Software License|
|Source code||Github repository|
The Plugin uses the Power BI REST API to interact with Power BI, and requires a valid access token to be able to submit requests. The information required to get an access token are:
You will need to register a client application. The main steps are as follows:
Please refer to this official Azure documentation in case of questions, and contact your Power BI administrator.
The Plugin provides the following components:
You can either use the Web App template to create a new Web App, or use the DSS Macro. The Macro is the preferred way, as it can be used in conjunction with DSS Scenarios for automation, and automatic refresh. It is available directly in your Project Macros once the Plugin is installed. Here is a screenshot of this Macro:
Power BI access token generation Macro
The Plugin will appear through the regular Export facility of DSS. For one-off export, just click on the Export function of a Dataset, and under "OTHER (CUSTOM)", you will be able to see the 2 custom Power BI exporters:
One-off export to Power BI
Export Recipe to 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" (default value), and the data types will be inferred from the DSS Dataset. Visualizations can be built from there:
Additional instructions are available in our Github repository