---
title: "Publish workbook and schedule refreshes - OData connector"
canonical: "https://support.appfire.com/space/ATCFJ/1109229570/Publish%20workbook%20and%20schedule%20refreshes%20-%20OData%20connector"
format: markdown
---
> Macro (aura-html)

This page describes how to publish a workbook (using OData connector) from Tableau Desktop to Tableau Cloud or Tableau Server and schedule data refreshes.

## Publish the workbook from Tableau Desktop to Tableau Cloud

In the following scenario, the workbook is published from Tableau Desktop to Tableau Cloud.

1. In Tableau Desktop, create the workbook that you want to publish. To import the data using the OData connector and create the workbook, refer to [Import into Tableau - OData](https://appfire.atlassian.net/wiki/spaces/ATCFJ/pages/1047822381).

 2. Navigate to **Server **> **Publish Workbook**.

![TableauDesktop_publishworkbook.jpg](media://b1258f55-0c60-433b-8dc1-5655d8b8a957)

3. The *Share via Tableau Server or Tableau Cloud* dialog opens. To publish the workbook on Tableau Cloud, click **Tableau Cloud**.

> 📝 If you want to publish the workbook to Tableau Server, choose Server and log in by providing the details. For more information, refer to [Sign in to Tableau Server or Tableau Cloud](https://help.tableau.com/current/pro/desktop/en-us/sign_in_server.htm).

![TableauDesktop_select_cloud.jpg](media://dcff8d72-aedc-478e-b864-c1331d3cc268)

3. To connect to Tableau Cloud, enter your **Username** and **Password**.
4. In the *Publish Workbook to Tableau Cloud* dialog, provide the publishing details.

- **Location**: Select the Tableau project** **where you would like to publish the workbook.
- **Name**: Enter a name for the workbook.
- **Description**: Provide a description for the workbook.
- **Data Sources**: To change whether the data is embedded in the workbook, published separately, or how to authenticate with data sources, click **Edit**.
  - If you are publishing an extract and want to set up a refresh schedule, select:
    - **Publish Type: **Embedded in workbook
    - **Authentication**: If the login credentials are set for the OData Connector URL, then the Authentication drop-down option appears. Select **Allow refresh access**.

![PublishWorkbook_details.jpg](media://136659da-a11a-4717-8d12-063c327b2eb5)

> 📝 If the login credentials are not set for the OData Connector URL, then the Authentication drop-down option is not displayed.
> 📝 
> 📝 ![Tableau Cloud_No Authentication.jpg](media://254dad40-251b-45f4-9ee4-24ea18260685)

6. Click **Publish**.

![Tableau_Publishworkbook.jpg](media://095598f6-de48-4480-8bac-79a45d5634ba)

 7. The Tableau Cloud opens in the internet browser, and the *Publishing Complete *dialog is displayed.

![Tableau_Cloud_workbook_published.jpg](media://dd56b687-6317-498a-a0a9-f8e0bcc514c4)

> 📝 To view the published workbook, under the View tab, click on the sheet.

## Schedule refresh on Tableau Cloud

> 📝 - If you want to schedule the extract refresh from the Jira Server, you need to Whitelist the IP of the Tableau Cloud in the Jira Server.
> 📝   - If the Jira Server is Cloud hosted - Update the In Ingres rules.
> 📝   - If the Jira Server is on-premises - Update the network rules to allow incoming traffic.
> 📝 - Tableau Cloud IPs are as per [Authorize Access to Cloud Data Published to Tableau Cloud](https://help.tableau.com/current/pro/desktop/en-us/publish_tableau_online_ip_authorization.htm).
> 📝 - For reference, If the Tableau Cloud is hosted in the region <u>[prod-apnortheast-a.online.tableau.com](http://prod-apnortheast-a.online.tableau.com/)</u>, then you need to whitelist the IP 18.176.203.96/28 in the Jira Server Ingres rules.

In the following scenario, the extract refresh is scheduled from the Jira Cloud.

1. To schedule a refresh, go to the Tableau Cloud project where the workbook is located and navigate to **Extract Refreshes** > **New Extract Refresh**.

![TableauCloud_ExtractRefresh.jpg](media://f96be786-9580-4c5c-9a24-320e78065bec)

2. The *Create Extract Refresh *dialog opens. Set up the refresh frequency for a full refresh and click **Create**.
  1. You can set the frequency to hourly, daily, weekly, or monthly. For more information, refer to [Schedule Refreshes on Tableau Cloud](https://help.tableau.com/current/online/en-us/schedule_add.htm).

![Create Extract Refresh dialog.jpg](media://e20e804c-4c6d-4f60-99a5-d893f6c09955)

 3. The refresh is created, and the workbook will be refreshed according to the set schedule.

![RefreshDetails.jpg](media://8e5e67c7-21a7-4a0e-8cba-4a4dc411e737)

4. To view the scheduled refresh details of all the data sources, in the left navigation, click **Tasks**.

![Tableau_cloud_tasks.jpg](media://682e7e43-c6a1-4bfe-ae25-42fb962c1148)

5. To view the status of all the scheduled refresh tasks, in the left navigation, click **Jobs.**

![Tableau Cloud_Jobs.jpg](media://d97ffc2c-db28-4e21-aafb-e8e8789d1b81)

6. To view the refreshed data, navigate to the Tableau Cloud project and click on the Workbook. Under the **Views** tab, click on the workbook to view the data.

![Workbook_view.jpg](media://8e2081b4-2f59-4b5d-9bc7-cbffeb082345)

> 📝 - To run the refresh manually on demand, under **Actions**, select **Run Now**.
> 📝 - To change the schedule frequency, under **Actions**, choose **Change Frequency**.
> 📝 
> 📝 ![Refresh_RunManually.jpg](media://540887b2-4a7e-4ff7-82bb-023715392999)