This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
So I have a requirement to provide a report to a team via Tableau, sourcing the data from a SharePoint list, and they want the entire revision history included in the report as well.
Using a DOS script, I execute a PowerShell script to pull all the report info from SharePoint.
Then I use Alteryx to convert the XML into a CSV file and publish it directly to the Tableau server using the "Publish to Tableau Server" tool.
I currently have my Alteryx Workflow set up with Events enabled, and to run my DOS script before the workflow is executed, and it works great.
I am going to need to set the workflow up on the company gallery - how/where do I put the script on the gallery server so that the workflow can access and run it when the workflow is run from the gallery? or will the user(s) have to have a local copy of the script on their machines?
Is it possible to "embed" the script into the workflow so that a separate .bat file is no longer needed?
Is it possible to run the workflow automatically by Tableau whenever the report is generated/refreshed?
3 - Yes, I am hoping that Tableau has reciprocated the good will of Alteryx (with the Publish to Tableau tool) by providing a way for Tableau to execute an Alteryx workflow as part of the report retrieve/refresh process.