Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
bo_afk
Post Patron
Post Patron

Can't view reports even when permission granted

I've published some reports onto Power BI server and I've shared these with some colleagues around the business, who also have a Power BI Pro account.

 

However, when some of my colleagues try to access the reports, they get an error message telling them that they require permission to access the report and dataset. I've double-checked on my end and I can see that they have definitely been granted access to everything. What is odd is that some are able to view but some aren't.

 

Has anyone experienced anything similar or can perhaps advise on something I haven't checked yet?

 

Thanks

afk

1 ACCEPTED SOLUTION
bo_afk
Post Patron
Post Patron

Hi @v-diye-msft , @ibarrau 

 

I've finally fixed the issue. Seemed like the user had "two" email addresses. A normal one with firstname.lastname@company.com, and the other a shortened version FirstinitialLastname@company.com.

 

When searching their name via Power BI service on the permission/access page, their shortened email had appeared in the list and I'd originally granted access to that email. However it looks like it's their other email that I was supposed to give access to as I had then manually typed in their longer email and granted access to that and it worked.

 

Although I'm not too sure why this is the case as I checked the user's Power BI account and it was registered under their shortened email address.

View solution in original post

3 REPLIES 3
bo_afk
Post Patron
Post Patron

Hi @v-diye-msft , @ibarrau 

 

I've finally fixed the issue. Seemed like the user had "two" email addresses. A normal one with firstname.lastname@company.com, and the other a shortened version FirstinitialLastname@company.com.

 

When searching their name via Power BI service on the permission/access page, their shortened email had appeared in the list and I'd originally granted access to that email. However it looks like it's their other email that I was supposed to give access to as I had then manually typed in their longer email and granted access to that and it worked.

 

Although I'm not too sure why this is the case as I checked the user's Power BI account and it was registered under their shortened email address.

v-diye-msft
Community Support
Community Support

Hi @bo_afk 

 

1. Make sure there no RLS rules implemented in the report. and if RLS involved, please confirm they're granted the access both in dax formula and the security in the dataset. details refer to https://docs.microsoft.com/en-us/power-bi/service-admin-rls 

 

2. Please describe which way you share the report. 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
ibarrau
Super User
Super User

Hi. First of all, can you tell us about the report? what data sources are involved? how did you share with users? (adding in workspace with role, share report, share dashboard).

Be sure they all have pro licence. Ask them to check it.

 

Last, are all of them in the same organization?

Regards,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.