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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. 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 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
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors