Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
power_bi_dev
Frequent Visitor

Access Denied

‎07-11-2020 04:37 AM

We have a PBI RS installed. I posted a report and started assigning users accidentally deleted my profile and lost the ability to manage the report. And now this report can only be used by a number of people and no one can change it. How do I restore rights to this report?

Labels:
Message 1 of 4
4,855 Views
0
1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion
In response to power_bi_dev

‎07-12-2020 01:48 PM

@power_bi_dev 

as you are a server admin you can try to play with SRSS DB with SQL.

You need tables like dbo.Policies, dbo.Users, dbo.Roles and dbo.Catalog

But I haven't ever tried to fix it via direct SQL Update 🙂


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Message 4 of 4
4,770 Views
3 REPLIES 3
az38
Community Champion
Community Champion

‎07-11-2020 11:22 AM

@power_bi_dev 

don't you have granted admin rights?

republish report isn't a good option for you?


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Message 2 of 4
4,815 Views
0
power_bi_dev
Frequent Visitor
In response to az38

‎07-12-2020 04:58 AM

I have admin rights to everything except this report. I don't have a copy of the report. That's why I can't republish it.

Message 3 of 4
4,796 Views
0
az38
Community Champion
Community Champion
In response to power_bi_dev

‎07-12-2020 01:48 PM

@power_bi_dev 

as you are a server admin you can try to play with SRSS DB with SQL.

You need tables like dbo.Policies, dbo.Users, dbo.Roles and dbo.Catalog

But I haven't ever tried to fix it via direct SQL Update 🙂


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Message 4 of 4
4,771 Views

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All