Query PBRIS (onprem SQL Powerbi )

[Anonymous]

Hi,

how to extract from SQL Server PowerBI onprem who is assigned to the permissions of a particular report,

I would like to know,

The path to the report\ the report name\loginuser -  permission level.

[Anonymous]

anyone help, know the solution ?

[v-jingzhang · Accepted solution]

Hi @Anonymous

Please refer to this thread Exporting list of those with access to the Report - Microsoft Power BI Community 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Anonymous]

HI,

I need constant monitoring, maybe you know or have a query in SQL on PowerBI Server, I tried to solve this but I failed.

[v-jingzhang]

Hi @Anonymous 

Do you mean something like Powershell or Rest API or other methods to query the list directly rather than from the Manage permissions page in the web browser?

Jing

[Anonymous]

The powerBI server has its own SQL server, I am connected to it, I need to pull from it with a standard "selecet" query the information about the people in the security tab.