Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
167
Views
Topic starter
Hi,
I have a big data set, that is refreshed every day. Is it possible to save automatically data from query to backup excel or csv file before refreshing? I know that it´s possible to upload data to power BI and then do export to CSV however it has to be done manually.
Many Thanks,
Dan
Posted : 13/11/2018 8:16 am
Hi Dan,
You'd have to write some VBA/Macro to do this. There's nothing in Power Query that can do this automatically.
Mynda
Posted : 13/11/2018 6:35 pm
