***BUG*** Power Automate Email alert raised by KPI Tile Alert has wrong value for field Tile Value
I have several Power Automate flows that i have created and tied to alerts raised by KPI Visualization tiles on a Power BI Dashboard. The alerts generated by the dashboard are fine, but when i use the "Tile Value" in the PA Flow, I am getting incorrect values in the subsequent emails or adaptive cards.
4 Comments
- v-cazheng-msft
Community Support
Status changed:NewtoInvestigatingHi jfox0603
Thanks for your feedback. Could you please provide a screenshot to let me know how you set your Power Automate flow so I can test at my side?
Best Regards,
Community Support Team _Caiyun
- jfox0603Frequent Visitor
Thanks for the response. Here are a series of screen shots.
KPI Viz on Dashboard
Dashboard Alert Setup
Flow Definition
Power BI Alert...Note Current value is 291322, which is correct
Flow Alert Message - Notice current value shows 246,841...incorrect. Threshold is correct, and the 36,000 is hard coded in the flow def.
- v-cazheng-msft
Community Support
Hi jfox0603
Thanks for your reply. But I can't repro it at my side. Please consider opening a support ticket be following the steps in the blog below and then there will be a support enginert help you troubleshoot on this issue. Thank for your cooperation and understanding!
Blog: How to create a support ticket in Power BI - Microsoft Power BI Community
Best Regards,
Community Support Team _Caiyun
- jfox0603Frequent Visitor
Note...if i change the date range on the KPI to just the current date, the alert through Power Automate works as expected. it just gives incorrect values when more that one day is shown in the KPI. Is it grabbing an average or some other summarization???