How to export data to shared drive without Data Shuttle?
Looking for a way to schedule an excel file export that goes into a shared folder to automatically connect to powerBI. A workflow from Smartsheet to a shared drive would be ideal and allow our dashboard to be automated.
Since we don't have data shuttle, it seems like the Live Data Connector could solve this issue but looking for advice from people who have done this.
Answers
-
Why do you need it to go to excel if you have Power BI? Could you not set up a dataflow to accomplish what you need?
-
@jaimelynn0814FEB Thank you for pointing this out. This ask is from someone else so I'm not familiar with why they're wanting to export this way. I'll ask them why they can't set up a dataflow. I'm, obviously, not familiar with Power BI at all so didn't know this was possible.
ETA: They said if they connect directly from Power BI, they lose history if someone deletes a row.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 395 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
