Report Builder Row Level Security Not working in Power BI service

Hi All,

The row level security implemented in the Report Builder report is not working when published to Power BI service. When running the Report builder (.rdl) report in Power BI service, the report is using the credentials of the user that is used to create the data source in Power BI Gateway settings. We want the report to use the credentials of the user running the report instead.

How can this be achieved?

Below is info on our setup:

- Application used to create report - Power BI Report Builder

- Data Source for the report - On Premise SQL Server DB (Relational)

Thanks,

Sandeep