Writing Job Results into Microsoft Power BI

This article explains how to write job results directly into your Microsoft Power BI Datasets.

Table of Contents

Prerequisites

Usage

Visit Treasure Data console, go to query editor, and enter your query into the query editor. Click on Output results.



Choose saved connection

A dialog Choose Saved Connection will be displayed. You will need to select an existing power_bi connection (see image below). If you do not have a Saved Connection already setup, please follow the next step on how to create a new connection within the Sources Catalog.



Create a new connection

Visit Treasure Data Connections search and select Power BI. The dialog below will open



Please select an existing OAuth connection for Power BI, or click the link under OAuth connection to create a new one.

Create a new OAuth connection

Please sign in to your Power BI account in popup window



You will get a list of permissions you need to grant access to. Click on the Accept button.



You will be redirected back to Treasure Data Connections. Please repeat the first step (Create a new connection) and choose your new OAuth connection, finish creating the connection.



From here, you will be able to use the new power_bi connection in Choose Saved Connection.

Additional configuration

After select power_bi saved connection or create the new one, you need to input the Dataset and Table fields to create a new Power BI dataset & table or update the existed one.



Basic usage

Write the query

Please visit the Treasure Data Console query editor page and compile your query.

Execute the query

Finally, either save the query with a name and run or just run the query. Upon successful completion of the query, its result will be automatically imported to the specified Database destination.


Last modified: Mar 21 2017 10:36:24 UTC

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels.