Unanswered

Dataverse Roles for Power BI Reporting

(1) Share

Report

Posted on by Jared.Leonard

Hello All,

I've made a Power BI report that pulls in data from the Dataverse. I have users that want to use this report, pulling in the same data. Those users do not have the same security roles as me. What kind of account does a user need to access the Dataverse in this way? And, which security roles, and set in which locations, would allow a user to log into Power BI and pull fresh data from the Dataverse?

Thanks,

Jared Leonard

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (2)

Report

Hello @JLeonard

Hope you are doing good.

If the User want to READ only the record then Please provide "Service Reader" Security role.

Steps:

1. Navigate to https://admin.powerplatform.microsoft.com
2. Click Settings at the top
3. Click Users + Permissions --> Select User
4. Now Open the User (Whom you need to provide permission) --> Select Service Reader Security Role
5. Click Save 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
schuess3 353 on at

Like (3)

Report

The problem with this solution is

"This role can't be assigned to a user or team."

https://learn.microsoft.com/en-us/power-platform/admin/database-security

Was this reply helpful? Yes No
ekru222 69 on at

Like (0)

Report

Are there any work arounds?

Was this reply helpful? Yes No
Jared.Leonard 40 on at

Like (0)

Report

The above accepted solution is what ended up working for me, if it isn't for you, you'd need to provide more details in a separate post so that people don't assume your issue was solved.

Was this reply helpful? Yes No