Forum Discussion

amitgawali's avatar
amitgawali
Frequent Visitor
8 years ago
Solved

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

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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