Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Please can you help?
We have built alerts in the online service from a reporting dashboard built from a direct query to SSAS Tabular cube in which the data refreshes once a day. We are getting multiple sends of the alerts prior to the data cube finishing it's refresh. The alerts then re-trigger once the data has actually refreshed.
We have set the cache refresh to an hour, but on occasion it seems the alerts are firing before the cube data has refreshed. This is creating noise around the alerts that we need to see. We have looked at lots of things to try and stop this happening but are out of options now - so frustrating!
Any ideas? Please let me know if you need more details?
Thanks
Ajp
Hi @Anonymous,
Perhaps you can take a look at power bi automation to create a flow to trace your dataset status:
Integrate Power BI data alerts with Power Automate
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.