Installing the Connector
The CData Power BI Connector for Google Sheets includes comprehensive high-performance data access, real-time integration, extensive metadata discovery, and robust SQL-92 support.
Install the Connector
Complete the following steps to install the connector:
- Download and run the CData setup.
- Setup prompts you to install Microsoft Visual C++ 2017 Redistributable. Proceed with the installation.
- Once the installation is complete, click Finish.
The installation process creates a data source name (DSN) called CData Power BI GoogleSheets. A DSN is the name that applications use to request a connection to a data source.
See Creating the Data Source Name for the next step, which includes authenticating to the Google Spreadsheets APIs.