PowerBI Dataset to Google Drive 1.0.0

A seamless connection mechanism enabling the automatic transmission of Power BI dataset information to Google Drive, facilitating secure storage, collaboration, and accessibility of data across platforms for enhanced analysis and reporting capabilities.

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 Google Drive. 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 Google Drive. If the parameter Compression is set to true, the CSV file will be compressed and uploaded to the desired location in Google Drive. The loaded file will be named DatasetName_currentDate.

To run this integration and connect Power BI to Google Drive, 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.

Google Drive

• Token File Required. Select the Google Drive Rest Token file from the drop-down list. Review the KB-Article mentioned here on how to generate the token file.
• Target Location Required. Specify the path to the target location ending with a trailing slash.