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

(0) Share

Report

Posted on by WebPortal

2,295

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

I have the same question (0)

All responses (5)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

@AhmedSalih
What do you mean, the role assignment?

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@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

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

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

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

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.

Was this reply helpful? Yes No