Power BI Connector for Smartsheet

Build 23.0.8839

Installing the Connector

The CData Power BI Connector for Smartsheet 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 Smartsheet and copy the CData.Smartsheet.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 Smartsheet Source and a system DSN called CData PBI Smartsheet Sys. A DSN is the name that applications use to request a connection to a data source.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839