Trigger an email for blank values in Power BI Service

[POSPOS]

Hi All,

I have a requirment to trigger an email to user with only the blank columns.

Below is my table.  

Here Region 4 and Region 5 are having blank City, so my requirement is to email the user with the below data  . When ever there is blank city, email has to be triggered with all the regions that have blank city.

Can someone please suggest on how this can be done?

Thank you.

[Anonymous]

Hi @POSPOS ,

What is your data source? Is the report's data in sync with the data source data? Does blank data often appear when the data source data changes?

If your data source has a corresponding trigger in Power Automate, I recommend that you use Power Automate flow to complete everything. Flow supports getting data from a data source and inserting it into an email.

Here is an example:
1. Trigger the flow when data is modified
2. Filter rows with blank city in the data source
3. If the filter result is not empty, the flow sends an email, and the email content contains the region with blank city.

Best regards,

Mengmeng Li

[POSPOS]

@Anonymous  - Sorry, I accidently clicked the solution as accepeted.
Can you please provide steps on how to do this?
Where should this be created?

Step 1 - Should this step be in Power Automate? What action should be used?

Step- Where should the filter condition be applied?

[Anonymous]

Hi @POSPOS ,

It's ok, you can cancel the solution. Could you please answer some of the questions in my previous reply? This is related to how to design the flow.

Best regards,

Mengmeng Li

[POSPOS]

@Anonymous  - 

Please find the details below - 

What is your data source? - Created a Power BI report onSAP BW Bex Query

Is the report's data in sync with the data source data? - Yes, the data is in sync

Does blank data often appear when the data source data changes? The blank records may come up. We do not have an exact interval on how often the blanks comes up

[Anonymous · Accepted solution]

Hi @POSPOS ,

If the blank values ​​are irregular, I suggest you consider the trigger mentioned by @nilendraFabric (When a data-driven alert is triggered).

The second step is to get the data. Currently, the BAP BW connector requires you to have a Power Automate Premium license.

Finally, filter the blank values ​​and then determine whether the filter result is empty. If it is not empty, insert the region into the email and send it. The flow is like this.

This method may require data conversion, which requires knowledge of Power Automate. I am not an expert in SAP BW and Power Automate, I would recommend you to submit a support ticket to get professional help.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[nilendraFabric]

Hello @POSPOS 

Create a measure using this Dax

IsBlankCity = IF(ISBLANK([City]), 1, 0)

 And 

Create a visual (e.g., a card or table) showing the rows with blank “City” values and pin it to a dashboard.

Create an alert that triggers when the count of blank rows exceeds `0` on this visual 

In power automate 

Select Create > Automated Cloud Flow.
• Choose the trigger: Power BI - When a data-driven alert is triggered.

Add a condition to check if there are any blank rows.
• Use an action like Send an Email (V2) to configure the email notification

In the body. Use dynamic content from Power BI to include details about the regions with blank “City” values

Please give it a try 

[POSPOS]

@nilendraFabric  - I am trying to show the data in the table. 

1. Create a visual showing blank city == Should I be restricting the table whern measure=1?

2. Create an alert -== I need to create an alert on the table. There is no option to create an alert on table when the table is pinned to a dashbaord.

.

[nilendraFabric]

You can restrict the visual as you like. Its mainly to trigger the alert when city is blank

https://www.winwire.com/blog/power-bi-alerts-with-power-automate

[POSPOS]

@nilendraFabric  - Thanks for the article, but my requirement is to send the data as well,  that is the regions with blank city.

The link shared only notifies when the alert condition is satified but does not allow to add the details like the Regions names that has blanks

[nilendraFabric]

Can you try this 

In the body. Use dynamic content from Power BI to include details about the regions with blank “City” values

[POSPOS]

@nilendraFabric  - Dynamic content does not give an option to enter blank city values.