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:

1. Download and run the CData setup.
2. You may encounter the error "This setup could not copy important connector files to C:\Users\<your username>\Documents\Power BI Desktop\Custom Connectors."
   • This usually occurs because the Windows account used to install the connector doesn't have permission to write to the "Custom Connectors" folder.
   • To resolve this, navigate to C:\Program Files\CData\CData Power BI Connector for Google Sheets and copy the CData.GoogleSheets.pqx file to the "Custom Connectors" folder.
3. The setup prompts you to install Microsoft Visual C++ 2015-2022 Redistributable. Proceed with the installation.
4. After the installation is complete, click Finish.

The installation process creates a user data source name (DSN) called CData GoogleSheets Source and a system DSN called CData PBI GoogleSheets Sys. A DSN is the name that applications use to request a connection to a data source.