Power Automate - How to export Data to current user's OneDrive root folder
Is there a way to create a button to trigger a flow in Power Automate to extract data from a Power BI dataset (run query against a dataset) and store the result in a csv/excel file in the current user's OneDriver for Business root folder?
The way we managed to create it, it always save on the One Drive root folder of the flow creator.
This is a tricky situation, because the connection would need permission on the user's OneDrive to do this. Your connection will not have this access unless the location has been shared with them.
I think you may be able to configure the connection to use the connection of the flow initiator (not at a computer right now so can't check myself), which would let you use the normal OneDrive actions - assuming you can architect it so that the user is the one to kick off the flow. I know you can configure this when running list flows, but I'm not sure if other types allow it.