How to run the Tableau workbook with .hyper extracts in Tableau Online?

Question

I am familiar with Tableau dev and developed a report that uses 2 .hyper extracts and one Excel file and it is running fine with correct data. This is from Dev environment.

But client need to run from Tableau Online, now I am not aware (in fact no knowledge) on how run a workbook on tableau online with this setup.

I am trying to get answers to the below points:

1. How to refresh Tableau .hyper extracts?

2. How to specify Excel location (to pick new one every time workbook is refreshed)

3. Refresh Tableau workbook to show new data every time.

Answer 1

Currently Tableau Online cannot reach files on a local network.

Tableau Online in the cloud cannot reach data sources that you maintain on your local network. Depending on the connection, you might be required to publish an extract and set up a refresh schedule using Tableau Bridge. Source: https://onlinehelp.tableau.com/current/pro/desktop/en-us/publish_datasources_about.htm

If by "Online" you mean Tableau Server, then there is a way to refresh the data from an Excel data source. Please, check this official link: https://kb.tableau.com/articles/howto/automatically-updating-data-in-server-workbook-that-uses-live-connection-to-excel

Could you give more details about your extracts? If your hyper extracts are from a published datasource, then you can refresh them easily. You just need to create a schedule for the workbook, after publishing it. It is necessary to "allow refresh access" like shown in the screenshot below.