Power BI Dataset to Amazon S3 by COZYROC

Our integration solution orchestrates the extraction of data from a Power BI dataset and efficiently sends it to an Amazon S3 bucket. This streamlined process ensures that the latest insights generated in Power BI are securely stored in Amazon S3, facilitating further analytics, archiving, or sharing of the data.

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 Amazon S3. 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 Amazon S3. If parameter Compression is set to true, the csv file will be compressed and uploaded to an Amazon S3. The loaded file will be named DatasetName_currentDate.

To run this integration and connect Power BI to Amazon S3, 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 on 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.

Amazon S3

• Server Host Required. Provide the relevant [bucket] and [region] in the Server URL.
• Access Key Required. Specify the access key for Amazon S3 service.
• Secret Key Required. Specify the secret key for Amazon S3 service.
• Destination Folder Required. Specify the path to the destination folder ending with a trailing slash.