What is Google Drive - Google Drive is a storage service offered by
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:
Data Source button in the configuration panel to add a new data connection.
CREATE NEW to launch a new connection from the connection type panel.
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.
Select and then preview window will appear. Here, you can choose your preferred
Tables and Columns.
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
Save to save the data source.