Answered

Is it possible to use the power automate visual in powerbi, to call an API and save a file on the users onedrive.

(0) Share

Report

Posted on by s_raja

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?

Thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
s_raja 39 on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

s_raja 39 on at

Like (1)

Report
Copy link

Link copied!

Final solution was to create a powerapp which called the flow, then using the powerapp visual for powerbi, which allowed the flow to run per user.

Was this reply helpful? Yes No