Error Access denied when trying to download a file from a Dataverse table

(0) Share

Report

Posted on by WebPortal

2,297

Hello,

I'm trying to download a file from a Dataverse table with the expression:

Download("https://orgxxx.crm4.dynamics.com/api/data/v9.2/cr43d_tablexxxes(50e81adc-4e38-ee11-bdf4-000d3aaa0ef9)/nn_anexos/$value")

Which is returning the error:

Server Error in '/' Application.
Access is denied.
Description: An error occurred while accessing the resources required to serve this request. This may have been caused by an incorrect user name and/or password.

Error message 401.1: Logon credentials were not recognized. Make sure you are providing the correct user name and password. Otherwise, contact the Web server's administrator for help.

My user roles in this environment:

Approvals user

System administrator

Basic user

The table configs:

Categories:

Microsoft Dataverse with Power Apps

All responses (5)

Answers (0)

Sort by

AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @WebPortal, are you including the authentication from where you are using that expression?

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

@AhmedSalih
What do you mean, the role assignment?
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@WebPortal, whoever running that expression against the dataverse, needs access to the data. You need security roles assigned to the user/serviceaccount/flow owner that is accessing the dataverse tables.

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

@AhmedSalih

I keep getting the same error, I did a lot of trial and error, but can't figure out what kind of permissions I must grant to the security role to allow users to open a tab and view the attachments.

Can you help?

Thanks in advance!
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

Does anyone know what the permissions are for allowing a user to preview or download a file from Dataverse?

Still, haven't found a solution.