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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

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. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!