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
- Basic knowledge of Treasure Data, including the toolbelt.
- A Microsoft Power BI account as an organizational user for Azure Active Directory tenant who can grant permissions to Treasure Data.
Choose saved connection
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
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.
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.
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