Smartsheet offers an easy platform for collaboration and file sharing. The Smartsheet content pack for Power BI provides a dashboard, reports and dataset that shows an overview of your Smartsheet account. You can also use the Power BI Desktop to connect directly to individual sheets in your account.

Connect to the Smartsheet content pack for Power BI.

Note: Smartsheet admin account is preferred to connect and load the Power BI content pack as it has additional access.

How to Connect

  1. Select Get Data at the bottom of the left navigation pane.

  2. In the Services box, select Get.

     

  3. Select Smartsheet > Get.

  4. For Authentication Method, select oAuth2 > Sign In.

    When prompted, enter your Smartsheet credentials and follow the authentication process.

  5. After Power BI imports the data you will see a new dashboard, report, and dataset in the left navigation pane. New items are marked with a yellow asterisk *, select the Smartsheet entry.

What Now?

What's included

The Smartsheet content pack for Power BI includes an overview of your Smartsheet account, such as the number of workspaces, reports and sheets you have, when they're modified etc. Admin users will also see some information around the users in their system, such as top sheet creators.

To connect directly to individual sheets in your account, you can use the Smartsheet connector in the Power BI Desktop.

See Also:

Get started with Power BI

Get Data for Power BI