Tableau Prep Builder: Connecting to files (Part 1 of 7)
Vložit
- čas přidán 3. 08. 2024
- In this first video of the series, I show you how to connect to files in Tableau Prep builder whether its a database, excel file or Tableau server, Tableau Prep Builder has a growing number of connectors available. -----
Join my Discord Server. / discord it's a little sparse at the moment but hang in there. Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
Hello Tim, I must say you explain the concepts in a precise manner. The videos are packed with only quality insights. I am grateful to be able to access your knowledge. Besides you also introduced me to other worthy youtube sources sqlbell & Data with Baraa. Thank you for adding so much value through your channel.
Wow, thanks! glad you enjoy them
Starting to learn Tableau today, and your explanation is clear and precise.
Subscribed
Great vids! Thank you!
Glad you enjoyed!
gracias bro , me ayudaste mucho
Hi Tim, love your videos! So useful! I was wondering how can i do a refresh to the Source data published to a server, it unioned files from a folder in Onedrive. I have saved the hyper file from Tableau Prep and published as Data Source. But it does not seem to update when new files are added. I click on "refresh Data Source" but nothing. I have files added to specific folder regularly, so want to automate that step if possible. Maybe you would have some advise?
Tableau server or online requires the data management add on to enable you to schedule prep flows on the server. In you're current setup you'll have to just manually runt he refresh and publish it in prep. Refresh data source only works on live databases where extracts are enabled or data sources linked to prep flows that have themselves been published. You can read more here: help.tableau.com/current/prep/en-us/prep_conductor_schedule_flow_task.htm
@@TableauTim Thank you so much, that is very useful!!
@@jetuke Happy to help!
How can we export Tableau prep output to an excel file ?
Please watch all the vidoes in the series. czcams.com/play/PLRfaJ7ZL0cF6JRvdxUV3FQSYG6OOH9Eta.html
@@TableauTim I have gone through them, you export to .hyper or CSV but not excel
@@DebayanKar7 Ah so in Tableaus capability csv files open in excel i guess you want excel-like formatting and tabs / sheets similar to Alteryx export to excel files. That's not possible just yet
You didn't put any files for us to work on? Sorry, going to another video where there are files for us to work on.
Okay no worries enjoy the videos. 👌🏾. If you watch the first video of this series you’ll realise the files are provided and I explain how to get them in pretty much every video. I’m also explaining concepts so it’s not a deal breaker, you could for example try the same steps on your own data and ask questions here if you get stuck. 🙌🏾 but no worries.