Power BI Connector for Smartsheet

Build 23.0.8839

Publish a Dataset

Publish a Dataset with Smartsheet Data

Make sure that you have configured a system DSN associated with the connector and that the DSN succeeds when testing its connection. If you do not have a successfully configured system DSN, see Creating the Data Source Name for configuration help.

Then, create and publish a dataset as follows:

  1. Open Power BI Desktop.
  2. In the Home ribbon, navigate to Get Data > Other.
  3. Scroll down the Other list until you find CData Smartsheet.
  4. Click CData Smartsheet, then click Connect. PowerBI Gateway displays the CData Smartsheet: Connector window.
  5. In Data Source Name, specify the name of a Smartsheet system DSN (the default system DSN is called "CData PBI Smartsheet Sys"), then select Import mode and click OK. PowerBI Gateway displays the Navigator window. In the left pane are directories of available tables in the selected data source.
  6. Click the folders to open them, then select your desired tables using the checkboxes beside their names.
  7. Click Load. The selected data appears in the Data pane, at right.
  8. Create a visualization.
  9. When you are ready to publish, return to the Home ribbon.
  10. Click Publish.
  11. Sign in to your Power BI account, if prompted.
  12. Name and save the .pbix file for the dataset. The chosen dataset name will be reflected on powerbi.com.
  13. If prompted, sign in with the Power BI account associated with your Power BI Gateway installation.
  14. Select the workspace you would like to publish the dataset to and click Select. Wait for the publication process to complete.

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