Power BI Dataset to Oracle Cloud Object Storage by COZYROC

Setup Guide

Execute Data Analysis Expressions (DAX) queries against the provided dataset. The dataset must reside in My Workspace or another workspace.

This integration will establish a connection between Power BI and Oracle Cloud Object Storage. Once the connection is established, the integration will then pull the queried data from the desired Power BI dataset specified in the parameter Dataset Name. The integration will then generate a csv file for queried data and send it to Oracle Cloud Object Storage. If the parameter Compression is set to true, the csv file will be compressed and uploaded to Oracle Cloud Object Storage.

To run this integration and connect Power BI to Oracle Cloud Object Storage, you need to configure the parameters that are mentioned below.

Power BI

• Token File Required. Select the Rest Token file from the drop-down list. Review the KB-Article mentioned here regarding how to generate the token file.
• Dataset Name Required. Provide the valid Power BI dataset name.
• Query Required. Specify a valid DAX query.
• Compression Optional. Set to true to zip the files.

Oracle Cloud Object Storage

• Server Host Specify correct bucketnamespace and region in the server host URL https://[bucketnamespace].compat.objectstorage.[region].oraclecloud.com.
• Access Key Specify the access key.
• Secret Key Specify the secret key.
• Destination Folder Specify the path to the destination folder ending with a trailing slash.