How to export multiple sheets from the Tableau view

One common use case is transferring data from Tableau to other analytics and visualization tools, such as Power BI and Looker Studio. However, a key limitation in this scenario is that the Tableau API retrieves the first sheet from a given Tableau view in alphabetical order. This can create challenges when fetching data from multiple sheets and views, potentially disrupting the intended data structure and workflow.

If you need to fetch multiple sheets from the same Tableau view, a possible workaround is to duplicate the view, rename the desired sheet so that it appears first alphabetically, and then use the updated link in Coupler for integration.

• Duplicate the Tableau View – Create a copy of the existing view to apply the workaround without affecting the original setup.

  

• Rename the Target Sheet – Modify the sheet name so that it appears first in alphabetical order, ensuring it is retrieved first by the API.

  

• Update the Link in Coupler – Use the new view’s link in Coupler to facilitate seamless integration.

  

  As a result you'll retrieve the desired sheet in Coupler witch matches the results of the same sheet in Tableau:

You can repeat the process multiple times by adding additional the required sources to obtain all necessary data. You can check how to on our Tableau Source Setup article.