Forum Discussion
How to pass to report using powerbi-client?
Hi hmendezm ,
Filters work well for selecting data, but they don’t directly impact calculations in a report. Since Power BI parameters can’t be dynamically updated per user in an embedded scenario, a different approach is needed.
A better solution is to use a measure in Power BI to dynamically apply the discount percentage. Here’s how you can do it:
-
Create a table in Power BI with possible discount percentages.
-
Use a measure to calculate the discount based on the selected percentage.
-
Pass the discount percentage from the web application as a filter when embedding the report, ensuring each user sees their specific discount without requiring a dataset refresh.
This approach allows discount calculations to update dynamically within Power BI, without modifying the dataset or triggering a full refresh. Let me know if you’d like more details on setting it up!
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
-
Hi hmendezm ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
To dynamically pass a discount percentage to an embedded Power BI report in an Angular application using powerbi-client, it's best to use filters rather than parameters, as Power BI Embedded does not support modifying parameters at runtime.
Apply a dynamic filter before rendering the report to ensure each user sees their specific discount based on their login details.
If the discount percentage is defined as a Power Query parameter, you can update it using the Power BI REST API. However, this requires a dataset refresh, making it less suitable for real-time updates.
To ensure each user only sees their relevant data, apply RLS to restrict access at the dataset level. This enhances security without requiring additional frontend filtering.
By combining filters for real-time updates, REST API for backend parameter management, and RLS for user-specific data control, you can ensure the report dynamically reflects user-specific discount values while maintaining performance and security.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Hi v-menakakota
Thank you very much for taking the time to reply to my question. We use filters in the report, and it works great to filter the data in the report. However, we need to use the percentage passed from the UI to calculate the percentages in a table. Is it possible in the transformation data section?
Best
hmendezm
Hi hmendezm ,
Filters work well for selecting data, but they don’t directly impact calculations in a report. Since Power BI parameters can’t be dynamically updated per user in an embedded scenario, a different approach is needed.
A better solution is to use a measure in Power BI to dynamically apply the discount percentage. Here’s how you can do it:
-
Create a table in Power BI with possible discount percentages.
-
Use a measure to calculate the discount based on the selected percentage.
-
Pass the discount percentage from the web application as a filter when embedding the report, ensuring each user sees their specific discount without requiring a dataset refresh.
This approach allows discount calculations to update dynamically within Power BI, without modifying the dataset or triggering a full refresh. Let me know if you’d like more details on setting it up!
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Hi hmendezm ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi hmendezm ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
-