Reading OData with windows authentification

[h3n]

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-authentication with OData. The windows-authentication is important because pretending from the authentication the result of the OData is different.

However, I have no success. It doesn’t seems to be a possibility in the gateway to schedule a query for refreshing the data source or initiate a refresh during start of the report.

In short my Question:

Is there a way to read an OData using windows credential of the logged on user to authenticate against the OData Stream?

Regards Henning

[Icey]

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]

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