Hi Andrée, what kind of error did you received?
Hi Andrée Roos! Thanks for sharing this. The extract is published up as flat file. Flows can be outputted as a Tableau extract (.hyper or .tde) or a CSV file which could be uploaded to a database. Tableau Prep cannot directly output to a database. Does that help answer your question? Please let me know. i can also reach out to the dev team if you have specific product feedback.
2 of 2 people found this helpful
Agree with Amanda. I believe the only way to refresh the data is to rerun the flow. The flow is not dynamic outside of Prep. We asked for refresh behavior in Beta so I would guess it is coming! Hopefully soon.
Hi Amanda, I have the same issue. Looks like if we do Data prep in Tableau PREP, we will have to manually refresh our datasources on a daily basis. Is there a reason why scheduling capability was not provided with Tableau PREP? Without scheduling feature, Tableau PREP would not be useful for our use case.
11 of 11 people found this helpful
No, there is no scheduling in the first version of Prep.
To add a little more detail: As Andrée notes, you can publish to Tableau Server from Tableau Prep. But Server itself doesn't really know anything about flows. When the flow runs, Prep pushes a new data source up to Server, but this data source just points to a Hyper database provided by Prep. The logic for re-running and producing that database never makes it to Server. If you want to refresh the data, you need to re-run the flow from Prep.
That said, scheduling is our number-one ask, and I don't think there's any reason to be coy about the obvious: we're working on it.
9 of 9 people found this helpful
Hi and thanks for all replies.
I must say I was a bit shocked when I realised that Tableau Prep is only used for static data extracts. This makes the tool pretty much useless, at least for my customers and makes it more like a tool for bloggers and perhaps for proof-of-concept when proper data is not in place. I thought this tool was here to compete with the scripting language of Qlik and all the tools included in a PowerBI environment, but I see nothing of that here.
I am a Tableau Solution architect for approximately 4000 Tableau Server users and almost 100 Tableau Desktop users and I can't see any of those benefit from Tableau Prep besides from working outside of Tableau, creating data output for other uses. In the enterprise world we work with large data volumes that updates and publishing static extracts in this way is not how people work.
Adding scheduling isn't adding 100% value to this tool, it is changing the tool from useless to something that would bring enormous value to our Tableau deployment. I do know that not all Tableau users come from the same enterprise environment as we do, but surely, a lot of the Tableau revenue must come from customers that have this need?
Also, if published extracts was added to this mix as data input, this work completely change the way we work with data and make a big jump in the direction where Tableau is thought of as a mature enterprise BI deployment. Our Tableau Desktop users can't access the larger datasources directly (think large Oracle database, cloud, etc.) so they need to use published extracts. They, however, very often want to bring something else into the mix where data blending won't do. This feature would make this crowd really happy.
I am however glad to see that you are working on a way to incorporate scheduling and I hope it will be implemented in a near future.
2 of 2 people found this helpful
I'm happy to wait for the server scheduling to be added later but I suggest you publish this in the documentation/blogs/official communication. It would save peoples time.
Other people are answering as if this is the 1st time Tableau has heard of the idea.
Is there some way to use a Windows Scheduled task to run the saved data flow as an interim solution until extract refresh is integrated? I tried calling the .tfl file with a scheduled task but it just opens the data flow dialog. Is there a parameter that would allow the scheduled task to open the .tfl AND run the data flow? Or is there something that can be done with tabcmd?
I fully agree--this is what we need as an interim step until a proper Server schedule is created.
If you are operating at that kind of scale, why would you be looking for a more mature solution like Alteryx?
Until great feature be launched, there is any API or SDK from Data Prep to do that ?
Tks a lot for your attention.
I have to echo this comment.
Without the ability to schedule refreshes, Tableau Prep is of no use to us at all.
Love the UX and we have managed to quickly solve some long standing pain points with minimal efforts using the tool. But not being able to run refreshes defeats the whole purpose of using Tableau Prep in the first place for us.
We are also an Enterprise deployment with over 500 Desktop users.
I'm going to add my voice to the chorus here as well. Learning that extract server refreshes are not currently supported in Tableau Prep renders it nearly useless for our organization (Enterprise deployment). It's a great tool and I love the UI, but missing the ability to schedule a refresh is a show stopper.