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 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
Community SupportHi 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.
- v-menakakota
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.- v-menakakota
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.
- v-menakakota
Hi hmendezm ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.