


For example, if you need to analyse intraday stock price data, it’s more efficient to pull the most recent data from a relevant API instead of downloading a static file and refreshing it in your Tableau Prep flow every couple of hours, or even more frequently.Īt the time of writing (February 2021), it’s not possible to connect to an API directly from Tableau Prep Builder. Such APIs allow to programmatically connect to a remote server and retrieve only the data that you are interested in. However, organisations are increasingly making their data available via specifically designed APIs (Application Programming Interfaces). But what if we want to add third-party data to our analysis? Sometimes such data comes in the form of static CSV or Excel files that we need to download first and then connect to in Tableau Prep Builder. Usually, to work with data in Tableau Prep Builder, we directly connect to a file or a database.
