Hi we are having some issues trying to load data from Salesforce into Tableau Prep, for whatever reason the previews on our larger tables will not load in a reasonable amount of time at all (3+ hours in some cases just to load the data preview) and this results in it being very difficult to develop new flows and test changes. Even after attempting to filter down or limiting the number of rows to pull it still will not load.
We have queried other sources (ex IBM db2) to pull a similar number of rows and we can typically get that data to load in almost instantly. Is there anything that we can do to improve the performance or is this a known issue looking for any guidance to improve load times because this is becoming a bit of a nightmare for our developers?
#Tableau Prep
came across your post trying to discover other ways to increase load time between Salesforce and Tableau Prep. Similar to what Diego shared, the best way I've found to increase load times from Salesforce in Prep is to use the Custom SQL option and query only the fields you need, and filter down in that step. It does use SOQL rather than SQL so there are some limitations there. However, when connecting directly to the Salesforce table in Prep, even if you filter down the input step, it still queries every single row and column despite the filter. Going the Custom SQL route actually does narrow the query down so I've seen much faster load times going that route.
If you've found any other solutions I would love to hear them if you're willing to share! My super large queries are still taking way too long for my liking so I'm trying to find anything else I can implement for faster loading times.
