Forum Discussion

h3n's avatar
h3n
New Member
6 years ago

Reading OData with windows authentification

Hi there,   in Power BI Desktop, I can use Windows-Credential for authentication of the logged on user to read an OData source. Now I like to publish the report and try to use the windows-authentic...
Icey's avatar
Icey
Community Support
6 years ago

Hi h3n ,

 

Is the following scenario what you want?

 

1. user A

  • creat a report
  • publish it to Power BI Service
  • add data source

  • enable gateway connection
  • check Data source credentials

 

2. user B

  • when he opens the report, it only displays the data he has access to.

3. user C

  • when he opens the report, it only displays the data he has access to.

...

 

If my understand is correct, please configure Row-level security (RLS).

If not, please let me know.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

h3n's avatar
h3n
New Member
6 years ago

Hi Icy

thanks for your answer. 

It is not exactly what I want. You are right that user b and c should only see special data for their own. Only user A should see all the data. When I use the Power BI Desktop, I am able to use the Windows Credentials. Wich data will be displayed for the user is realized in the selection for the OData. Therefore in Power BI Desktop it works. I am looking for the same possibility in the Power BI Service. Regards Henning