Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Kushagra
Frequent Visitor

Filtering of data using API

Hi,

 

My colleague has a PowerBI Pro license which they have used to embed their salary report in a shared workspace. I am trying to have a code created in React which helps my team members view the report's data (their own salary), but I need to filter it to show only certain data according to the type of user in my team (Manager/Developer/QA).  

 

We are using a schema basic to filter data, but it uses embed tokens instead. Is there any way we can filter data without having to use generate tokens API (POST https://api.powerbi.com/v1.0/myorg/GenerateToken)? I already have username and password of the PowerBI pro license holder.


 
1 ACCEPTED SOLUTION
2 REPLIES 2
VBLOT
Helper I
Helper I

Hello,

 

To filter the view according to the user, I do not know in React but you can use the RLS which basically creates Roles in the Report.

 

Check out : https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

 

Tell me if that helps.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.