1 of 1 people found this helpful
have you tried to extract your datasource and create a workbook package?
then connect your work book to the xlsx file you are updating so the changes will reflect to your workbook
I haven't tried that. I'm not exactly sure what the steps are to do that. Can you explain further?
Thanks for your help.
Im not particularly sure if this is what you need but it's quite a try.
Open your workbook, right click on your data source (xlsx) >> extract data. //this will attach the values in your xlsx file to your actual workbook.
Then, file >> export packaged workbook.. //This means that you can open your workbook to other tableau desktop without your original xlsx file.
When you open your packaged workbook you can change your data source with your updated xlsx file.
Or you can update your original xlsx file and use it as your data source.
*just a question, how are you updating your data source? or how do you plan to update your workbook?
Thanks Feds. Got it working.
As for your last question:
Updating is a manual process. You go into the Facebook page, extract the data (xlsx file), then I'll drop it into the data file that the Tableau Workbook is looking at.
I've heard of a way to connect directly to Facebook but I don't think it's possible anymore.
Thanks again for your help!
good to know.
I think you can use "Sentiment R" for fetching facebook data.
Sentiment R? I just did a Google search but couldn't find anything... Got a link or anything?
Try to search Sentiment in R, my colleague used this in fetching tweeter data and I heard from him before that he also used this in fetching data in facebook.