Alert when new row is added to database / Count of #

[corinnaelisa]

Hello,

I know this question has been asked before in various ways - so far I have not seen an answer that would help me with my problem.

The first column in my database simply indicates the number of the dataset/row and is named 'N.'. So far I have 127 datasets.

In my Power BI 'card'...

...I created an alert/reflex in Data Activator with the Select part being "Count of N.". However, no data is shown in the field.

In the Detect field my assumption was to select 'Changes' each time:

Also I receive following error message every time the data is trying to update:

Yet, as no data is shown this trigger won't work. Is there a work around? How can I receive email alerts every time a row/dataset is added to my database?

Thakn you for your help.

[v-tangjie-msft · Accepted solution]

Hi @corinnaelisa ,

Here are some steps you can take to troubleshoot and resolve this issue:

1.Ensure that the dataset 'N.' still exists and that its structure hasn't changed since you set up the alert. If it has changed, you may need to restore the original structure or adjust your Data Activator configuration to match the new structure.

2.Confirm that you have the necessary permissions to access the dataset. If permissions have changed, you'll need to re-establish them.

3.Sometimes, simply deleting the existing alert and creating a new one can resolve the issue.

You can try to create a Data Activator trigger by creating it from a Power BI visual object.

Best Regards,

Neeko Tang

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