Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Is there a way to clean old Active directory groups and users that are no longer used in PowerBI Report server?
We had removed lots of users and AD group from the PBIRS reports' permissions, but still those list of users area visible on [ReportServer].[dbo].[Users].
Thank you!
Solved! Go to Solution.
So there are some periodic clean up jobs that Report Server will run against it's internal database. But neither the database itself or those jobs are documented by Microsoft. But a quick look at the dependencies shows that the Users table is referenced by many other tables. Unless you think these extra records are causing significant performance issues I would not worry about them.
If you are concerned then you should raise an official support ticket with Microsoft. You should definitely not make an changes to the ReportServer database without specific instructions from Microsoft support.
So there are some periodic clean up jobs that Report Server will run against it's internal database. But neither the database itself or those jobs are documented by Microsoft. But a quick look at the dependencies shows that the Users table is referenced by many other tables. Unless you think these extra records are causing significant performance issues I would not worry about them.
If you are concerned then you should raise an official support ticket with Microsoft. You should definitely not make an changes to the ReportServer database without specific instructions from Microsoft support.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |