Forum Discussion
Update the Base Values to the Newer Values after a trigger point
Super UserHello Anonymous ,
instead of power automate you could use alerts in Power Bi where you set a threshold and if it was crossed an alert would notify a certain user by sending an email.
check it out here https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thanks for the prompt reply.
Oh that's great to know that there is such an option. Do you think I can do this too - Update the base table to the newest transaction value everytime an email is sent?
I have tried creating a base table by taking the recent values. What I want is everytime a new record is added to the main table it should compare it with the base table and if it more than 500 send an email. Sorry if my questions are silly, I am super new and internet doesn't seem to have a lot of info on this issue.
Thanks.