Auto connection refresh and publish to linked powerpoint
I have set up a chain to pull data from our data warehouse and then import automatically to a table linked to a query. This then is linked to an Excel file. I need to refresh the connection to get the new data. Once the new data is there I need to click the Publish button manually.
Can we automate refreshing connections in excel and publishing data to powerpoint?
Thank you for sharing your feedback with us! We have shared your suggestion with our product team and will let you know if anything changes. Anyone passing by is also encouraged to vote up/comment on this suggestion. Let us know if you have any questions in the meantime.
Quick update for you here Andre!
There should be an available Workiva command in the Chain to publish those links. Here's the Help documentation on that: https://support.workiva.com/hc/en-us/articles/360036005471-Workiva-commands#section490
Circling back here, Andre. I'm told this could also be possible via the APIs available. More info on those can be found here: https://developers.workiva.com/workiva-spreadsheets/reference/spreadsheets-overview0
Please sign in to leave a comment.