Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
amitgawali
Frequent Visitor

Getting data alert in Power BI from MySQL DB operations

Hi,

 

We have MySQL DB in one of our AWS box that will get updated frequently for some parameters. We want to have data alert on it.

So we have created connection of MySQL to Power BI Desktop and added KPI for a field and then published this to Power BI Service as .pbix file and pinned tile from it and added data alert for particular condition.

But whenever we do any modification to MySQL DB and that particular condition matches, data alert is is not getting trigerred.

First of all In Power BI we have to press 'Refresh' button to fetch the latest DB content and then we need to publish it again to Power BI Service, then only data alert is getting trigerred.

Can anyone help here as to how to fix this?

 

Thanks,

Amit

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @amitgawali,

 

Based on document, current data alert only works when data refreshed, so if you tile haven't setting refresh feature, it never triggered.

 

Tips and troubleshooting

  • Alerts are currently not supported for Bing tiles, or card tiles with date/time measures.
  • Alerts only work with numeric data types.
  • Alerts only work on data that is refreshed. They do not work on static data.
  • Alerts will only work on streaming datasets if you build a KPI/card/gauge report visual and then pin that visual to the dashboard.

Data alerts in Power BI service

 

For your scenario, please setting the scheduled refresh on your report/dataset to enable the data alert.

Configuring scheduled refresh

 

Regards,

Xiaoxin Sheng

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

View solution in original post

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

HI @amitgawali,

 

Based on document, current data alert only works when data refreshed, so if you tile haven't setting refresh feature, it never triggered.

 

Tips and troubleshooting

  • Alerts are currently not supported for Bing tiles, or card tiles with date/time measures.
  • Alerts only work with numeric data types.
  • Alerts only work on data that is refreshed. They do not work on static data.
  • Alerts will only work on streaming datasets if you build a KPI/card/gauge report visual and then pin that visual to the dashboard.

Data alerts in Power BI service

 

For your scenario, please setting the scheduled refresh on your report/dataset to enable the data alert.

Configuring scheduled refresh

 

Regards,

Xiaoxin Sheng

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

Thank you. It helped.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors