I have set up a flow which retrieves invoice attachments from an API.
I need to use it within powerbi, as a visual button, because users need to select a 'transaction ID' as trigger data (triggerBody()) for the flow.
The flow successfully retrieves the correct documents and saves them, but only into my Onedrive.
The users need to have the file saved into their own onedrive instead, because they are unable to access my onedrive.
We currently use Row level security to help differentiate users, but this does not affect my flow, and will still only download the files to my onedrive.
Is there any way to fix this?
Or is there a way to get the file to save to the users machine instead of to Onedrive?
Solved! Go to Solution.
@s_raja whose connection is associated with the flow ? Ideally the connection should be of service account so files are stored in service accounts onedrive and not yours. Not really sure if you can create a file in users onedrive, but may be you can keep the file in service accounts onedrive and use create a link action and share/provide access is something I could think of.
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
@jinivthakkar When testing this flow, without using the powerbi trigger, I was able to share the flow as 'run-only' and when the user clicked on the flow button it would run the flow, and save the files to their own onedrives.
So it is possible for others to save files, I guess I just need to find out how to make powerbi recognise the list of run only users and match them with the row level security.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!
Did you know that you could restore a deleted flow? Check out this helpful article.