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
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
