Forum Discussion

Giorgi1989's avatar
Giorgi1989
Icon for Advocate II rankAdvocate II
3 years ago
Solved

Alerts no longer triggered after scheduling dataflow/dataset refreshes via Control-M API

Hi,   I wonder if anyone has experienced anything similar and could share some tips:   So recently we started automating dataflow/dataset refreshes via Control-M.    The process goes like this ...
  • v-zhangti's avatar
    3 years ago

    Hi, Giorgi1989 

     

    Based on the information you provided, it seems that the dashboard tile is getting updated but the green bell icon is missing. This could be due to a refresh issue. There is a known issue where the Power BI dashboard in service displays a gray Power BI icon. The dashboard uses Azure analysis services data source through direct query. When the dashboard is left alone for some time (about 5 minutes), the visuals start loading successfully. When we manually refresh the dashboard, the dashboard visuals load the data successfully. This issue can impact email subscription for the affected dashboard to be sent out with Power BI gray Icon.

     

    It is also possible that the Power Automate alert is not being fired due to a refresh issue. Whenever you refresh data in a dataset, whether by using Refresh Now or by setting up a refresh schedule, Power BI uses information in the dataset to connect to the data sources defined for it, query for updated data, and then loads the updated data into the dataset. Any visualizations in your reports or dashboards based on the data are updated automatically. Regardless of how often you refresh the dataset, or how often you look at live data, it is the data at the data source that must be up-to-date first.

     

    It is recommended to check the refresh settings for the dataset and ensure that the refresh is happening as expected. You can manually refresh a dataset by using Refresh Now or setup a refresh schedule by using Schedule Refresh in a dataset’s settings. 

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.