Forum Discussion
REST API using Windows authentication
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.
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.