cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
APgoco
Frequent Visitor

Alerts Triggering when data not refreshed

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

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @APgoco,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
GilbertQ
Super User
Super User

Hi there,

This would be due to the fact that you have configured the cache refresh to be hourly.

What happens is each hour a query is sent to your SSAS Server, this then updates the cache, when then updates the Dashboard tiles.

Because you have got an alert on the dashboard tile, it gets updated from the cache refresh. And this in turn fires off the alert.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!