Reply
corinnaelisa
Frequent Visitor

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

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'...

corinnaelisa_0-1713254922490.png

 

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

corinnaelisa_0-1713254641864.png

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

corinnaelisa_1-1713254698213.png

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

corinnaelisa_0-1713255767611.png

 

 

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.

 

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

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.

vtangjiemsft_0-1713338653301.png

 

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. 

View solution in original post

1 REPLY 1
v-tangjie-msft
Community Support
Community Support

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.

vtangjiemsft_0-1713338653301.png

 

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. 

avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Kudoed Authors (Last Month)