Edit

Smartsheet

Note

This connector is owned and provided by Smartsheet.

Summary

Item Description
Release State General Availability
Products Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication Types Supported Smartsheet account

Note

Some capabilities might be present in one product but not others due to deployment schedules and host-specific capabilities.

Prerequisites

Before you can sign in to Smartsheet, you must have a Smartsheet account.

Capabilities Supported

  • Import

Supported Smartsheet Regions

The Smartsheet connector supports the Smartsheet US region (https://app.smartsheet.com) and Smartsheet EU region (https://app.smartsheet.eu).

Connect to Smartsheet

  1. Select Get Data from the Home ribbon in Power BI Desktop.

  2. In the search box, enter Smartsheet, select Smartsheet, and then select Connect.

    Screenshot of the Get Data dialog for Smartsheet.

  3. Select the region to connect to.

    Screenshot of the select region dialog where you select either US or EU.

  4. If you're getting data through the Smartsheet connector for the first time, a third-party notice is displayed. Select Don't warn me again with this connector if you don't want this message to be displayed again, and then select Continue.

  5. To sign in to your Smartsheet account, select Sign in.

    Screenshot of the authentication dialog where you select the sign in button.

  6. In the Smartsheet window that appears, select your sign in method and provide your credentials to sign in to your Smartsheet account.

    Screenshot of the Smartsheet window where you sign in to Smartsheet.

  7. Upon first sign in, you're prompted to allow the connector access to Smartsheet. Select Allow.

    Screenshot of the Allow access windows where you allow the connector to access Smartsheet.

  8. Once successfully signed in, select Connect.

    Screenshot of the authentication dialog indicating you signed in and are ready to connect.

Once the connection is established, you see the folders and workspaces you have access to within the Navigator dialog. Select the data you want to import and then select Load.

Screenshot of the navigator where you select the data you want to use.

Connect to Smartsheet from Power Query Online

To connect to Smartsheet data:

  1. Select Smartsheet from the Power Query Connect to data source page.

  2. In the Smartsheet dialog, select your Region (US or EU).

  3. Select Sign in to sign in with your Smartsheet account.

  4. In the Smartsheet sign-in window, enter your credentials and allow the connector to access your Smartsheet data.

  5. Once you successfully sign in, select Next.

  6. In the Choose data page, select the sheets, folders, or workspaces you want to load, and then select Transform data to transform the data in Power Query Editor.

Getting Help

If you run into problems when connecting to your data, Contact Support.

  • Last updated on