REST API using Windows authentication

[erikjanpoelen]

Hello everbody,

I would like to do a GET to a REST API to retrieve data in html or json.

The REST API works with Windows Authentication. It does not ask for a username and password but simply checks your windows account. That would be the following in Power BI:

The goal is that whenever an end-user is using this Power BI report through a workspace, they will only see the data (from this REST API) to which they have access to. Is that possible?

Using the WEB URL connector I can retrieve the data, but I think that's a simply import, so it will only use my credentials and access permissions are not applied for each user.

Please help!

[v-jingzhang · Accepted solution]

Hi @erikjanpoelen 

I'm afraid this is not possible. Since the data source is a REST API, it only supports Import connection. You need to use your credentials to import all data into the data model first. Then use these data to create a report. In Import mode, the data is always loaded into the report with a single credential. It cannot use end report users' credentials to connect to the data source. 

To restrict the data access for end users, you need to import data into the model first, then set up Row-Level Security on the report. Please refer to the following docs to get more information about RLS. 

Restrict data access with row-level security (RLS) for Power BI Desktop - Power BI | Microsoft Learn

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

The Dynamic RLS can restrict data access according to report users' login accounts. There are many blogs and videos introducing how to set up a dynamic RLS. Below is a video for your reference.

How to Apply DYNAMIC ROW-LEVEL SECURITY (RLS) with Power BI - Bing video

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