Want different users to see different data based on their key that is used in Custom connector

[darraghcass]

I have a custom connector and it gets data back from an API. Each user whitin the company has an API key which brings back different levels of data. I have a report and I want it to be able to change based on which user is viewing it. So if a person with a low level key logged in and viewed the report in the application they would only see as much data as the API key allows them. I have embedded this report using App owns data method but everyone is viewing the data using my API key which is used in the Gateway. Anyone know how I can get the report to be able to refresh the data for that user that logged in and show them the data that they have access too based on the API key

[GilbertQ]

Hi @darraghcass 

The best way to get this working is to import all the data into a single PBIX.

Then based on the API permissions use Row Level Security which will then only show the user the data that they have access to?

here are more details on how to use RLS: Restrict data access with row-level security (RLS) for Power BI Desktop - Power BI | Microsoft Docs

[darraghcass]

The problem is that with importing all the data won't work because the data needs to be constantly updated. I have looked into RLS and it doesn't seem possible with the API keys and different data that each key brings back

[Anonymous]

Hi @darraghcass ,

During the investigation, we found that other users had shared some good examples, and we hope they can help you.

API Works with RLS 

Best Regards,
Community Support Team _ Caitlyn

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