cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abdelmajid
Helper I
Helper I

Help with PBIRS ReportServer queries

Hello,

 

I need some help please with the following queries on Power BI reports server (PBIRS):

 

1-Query the list of Active Directory groups used in manging reports' permissions and the users within each group.

2-Query to lookup queries behaving bad on Database and map them them to the right report (RDL) file. That way we can reach out to the right report owner. 

 

Apprecaiate the help, thank you!

2 REPLIES 2
mpsrshl
Helper III
Helper III

1: SELECT
C.Name
,U.UserName
,R.RoleName
--,R.Description
,U.AuthType
,c.ItemID
,C.Type
,LDAP.employeeID
FROM Reportserver.dbo.Users U
INNER JOIN Reportserver.dbo.PolicyUserRole PUR
ON U.UserID = PUR.UserID
INNER JOIN Reportserver.dbo.Policies P
ON P.PolicyID = PUR.PolicyID
INNER JOIN Reportserver.dbo.Roles R
ON R.RoleID = PUR.RoleID
INNER JOIN Reportserver.dbo.Catalog c
ON C.PolicyID = P.PolicyID
left join [yourLDAPuserbasetable] LDAP
on replace(u.UserName,'[yourdomain]','') = sAMAccountName collate Latin1_General_100_CI_AS_KS_WS

 

2:

- Best advice is to switch SQL Profiler on.

- Collate the data from SQL profiler with the SSRS logs. 

 

 

 

 

v-janeyg-msft
Community Support
Community Support

Hi, @Abdelmajid 

 

I'm afraid it's hard to achieve. After my search, I didn’t find any relevant methods that meets your needs.

 

Best Regards

Janey Guo

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.