Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello everyone,
I would like to filter my queries in the way you see below through Power M and an if condition.
I would like to pass a parameter in a query and if that parameter is equal to the query value then execute the next query otherwise it does nothing.
I want to do this to make an embedded for customer of my report.
I ask you two questions in this regard:
1) is it possible to do that condition in Power M? do you have alternatives?
2) can I pass a parameter in Power Bi desktop and embed the report by passing the parameter in the code?
Thank you all
@Anonymous , If this pro, and you embedding, then you can use Service URL
https://docs.microsoft.com/en-us/power-bi/service-url-filters
Hi @amitchandak ,
Excuse me but is it very similar to creating an RLS?
I should limit access to the report because I would have to limit it based on user self-identification.
I would like to get the user ID and based on that ID I would like or not to have the query run and get the data.
I don't want to filter the data only.
I'm doing an embedded by customer so I only have a Masters credential that logs in and gets the token for the report.
I can't use a hierarchical RLS though because not all tables are linked and I don't have a hierarchy.
I would like the query to be executed only if the mail is linked to a certain ID.
Thanks
@Anonymous ,
Have you already explored this? see if these two can help
https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/embed-report
RLS in embedded
https://www.youtube.com/watch?v=yNF-_l2f7w0&feature=youtu.be
I am hopeful, you already done with token generation etc.
| User | Count |
|---|---|
| 21 | |
| 19 | |
| 17 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 60 | |
| 55 | |
| 47 | |
| 42 | |
| 37 |