URL for BI & Spreadsheets: Tableau

Modified on Tue, 13 Feb 2024 at 02:45 PM

Introduction

You can import live data from Gigasheet to Tableau with the URL for BI & Spreadsheets. Just follow these steps below.


How to get there

Step 1: Open Tableau Desktop: Start Tableau and go to the start page.


Step 2: Connect to Data: Choose "Web Data Connector" under the "To a Server" section. In the dialog box that appears, enter the URL of the Web Data Connector for CSV files. Tableau provides a Web Data Connector for CSV files which is usually found at https://tableau.github.io/webdataconnector/Examples/csv.html. This connector allows you to connect to CSV files over HTTP.


Step 3: Copy this link here: 

https://basic-csv-wdc.herokuapp.com/


And paste here: 



Step 4: Copy the URL for BI & Spreadsheets from the Gigasheet dialog. Once the Web Data Connector page loads, enter the URL of your Gigasheet link in the provided field.

Step 5: Proceed to initiate the connection. Tableau will then retrieve the data from the Gigasheet file


Things to Consider:

  • The exact steps might slightly vary depending on the version of Tableau you are using, but the overall process should be similar. 
  • File Location: The URL you provide must match the link provided by Gigasheet’s URL for BI & Spreadsheets dialog. Other URLs won’t work.
  • Data Refresh: Gigasheet automatically refreshes the data at this URL for continuous updates. Depending on your Tableau implementation you may be able to schedule data refreshes. In Tableau Desktop, this can be done manually by right-clicking on the data source and selecting "Refresh" or "Extract Data" if you are using an extract. In Tableau Server/Online, you can refresh the data source from the Data Source tab.
  • Note that Tableau is a separate product with its own support, pricing, and features.


Additional Tips:

You can test the Gigasheet URL in a private browser window to verify its accessibility.

If encountering issues, consider downloading the CSV locally and importing it from your computer to Tableau to test compatibility.



Still having issues? Contact us at support@gigasheet.com


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article