Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

Does anyone know of a way in Power BI to set query parameters as described here from an embed request instead of inside desktop? We are attempting to set up a system where we use power bi to power visualizations within our app for customers to view their data. We need to use some sort of parameter system to ensure that the query returns the proper customer data for the visualization.

1 Answer

0 votes
by (47.2k points)

We can use Row Level Security for this job. Let's say that we already have information about our customers in our fact table. We can create a role in Power BI Desktop that would filter data for a specific user using USERNAME() DAX formula. While pushing our pbix into Power BI service, we can associate roles with users.

Browse Categories