What is Google Drive
- Google Drive is a storage service offered by Google
to store files and folders in the web based cloud drive. It also provides support for synchronization service with your local devices that will keep the files sync with the Google Drive and add benefit for backup system and reduce the local storage usage.
Bold BI dashboard designer allows you to connect files which is uploaded in Google Drive
. It supports xlsx, xml, csv and json format files.
To enable this connection, follow the given steps:
Click the Data Source
button in the configuration panel to add a new data connection.
Click CREATE NEW
to launch a new connection from the connection type panel.
Click Google Drive
connection button in the connection panel.
New window will appear. Here, select your account or click Connect New Account
in the window opens.
The login window opens to authorize the user. Enter appropriate username and password for your account from which you want to access the Google Drive
data.
The authorization window opens. Here, click Allow
to authorize Bold BI application for downloading your Google Drive
files and view meta data for your files.
Now, Google Drive window appears. Set a data source name and choose file as shown in the following image.
Bold BI allows different Import
type for Excel files. Click here to know more.
You can schedule refreshes to keep your data on the dashboard up to date using Refresh Settings
option and click here to know more.
Now, click Select
and then preview window will appear. Here, you can choose your preferred Tables and Columns
.
Click Connect
and you will be navigated to data source designer page. Here, the worksheets/tables
are listed in a tree view on the left side of the editing window.
Now, drag and drop the worksheet/table
you want to analyze, and preview the data by clicking Update
.
Click Save
to save the data source.