Sharepoint Integration / Sharepoint Datasource

[Razvan_Irimie]

Hello,

We have the following scenario:

Sp on Prem with PowerBi Report Server

SPList 1 feeds data into a Pbi, the table has the following columns:

Store  Day etc.

1

2

3

BAck in Sp we have specific groups created which restrict vies for users to a certain store. Is there any way of tying the permissions from sp into the report. Alternatively we are trying to create a WebPart that will call the Pbi report via api and then query the tables and based on the value from the tables we can apply a filter in the URL for the embedded iframe using the rs:Embed parameter. 

My 2 questions are:

1. Can we tie in somehow the groups if not at least use RLS to filter access. Or At least somehow get the RLS roles via api when quering the report, when doing a /reports/api/v2.0/PowerBIReports(Path='/folder1/ReportName')/policies call on the report i get the actual policies for the Power Bi Report server not the report it self? When doing a /roles api call for the report i get the following:

{
  "@odata.context":"https://abcd.com/reports/api/v2.0/$metadata#Collection(Model.Role)","value":[
    
  ]
}

2. Can we at least query the report datasource via api to retrieve the table names, thus we cna push the data from the tables/columns/values into a form in the SP front-end and then build a Url filter based on the input ?

I have read the Swagger api doc(which is not very helpful btw) and also the existing documentation and i wasn't ablee to find anything relevant to the above.

[Greg_Deckler]

Is there a reason why you can't just use the Service where RLS works versus trying to cobble something together via Report Server? I mean, you may be able to cobble something together but to my knowledge, RLS isn't designed to work for Report Server.

[Razvan_Irimie]

Basically we need to filter somehow the data that is visible in the report based on the sharepoint user. To my knowledge We cannot use RLS for this as there is no way of retrieving the created roles. Can we get the Roles created in pbi desktop via api ?

[Razvan_Irimie]

Hello,

We have the following scenario:

Sp on Prem with PowerBi Report Server

SPList 1 feeds data into a Pbi, the table has the following columns:

Store  Day etc.

1

2

3

Back in Sp we have specific groups created which restrict vies for users to a certain store. Is there any way of tying the permissions from sp into the report. Alternatively we are trying to create a WebPart that will call the Pbi report via api and then query the tables and based on the value from the tables we can apply a filter in the URL for the embedded iframe using the rs:Embed parameter.  Thus we want to embed the PBI Report Server report into SP

My 2 questions are:

1. Can we tie in somehow the groups if not at least use RLS to filter access. Or At least somehow get the RLS roles via api when quering the report, when doing a /reports/api/v2.0/PowerBIReports(Path='/folder1/ReportName')/policies call on the report i get the actual policies for the Power Bi Report server not the report it self? When doing a /roles api call for the report i get the following:

{
  "@odata.context":"https://abcd.com/reports/api/v2.0/$metadata#Collection(Model.Role)","value":[
    
  ]
}

2. Can we at least query the report datasource via api to retrieve the table names, thus we cna push the data from the tables/columns/values into a form in the SP front-end and then build a Url filter based on the input ?

I have read the Swagger api doc(which is not very helpful btw) and also the existing documentation and i wasn't ablee to find anything rlevent to the above.