Technical Issues: External Outlook Trigger & Power BI Dataset Refresh

[Jeevan B]

Hi all, I'm facing two technical roadblocks with a Power Automate pipeline:

1. External Email Trigger: The flow triggers for internal emails but ignores emails from external domains. The trigger is set to the Inbox. Is there a specific tenant setting or "From" filter syntax required for external automated senders?
2. Stale Power BI Data: The flow creates items in a SharePoint list and calls the "Refresh a dataset" action after a 2-minute delay. The action returns "Success," but the Power BI Service report does not reflect the new records until a manual refresh is performed.

Environment:

• Source: CSV attachment (Parsed via split and skip).
• Database: SharePoint (Columns are "Single line of text").
• Visuals: Power BI Service with OAuth2 credentials.

Any advice on why the automated refresh shows success without updating the data?

 

[Chihiro]

1. Don't know what trigger you are using. But When a new email arrives (v3) has parameter you can set for specific "From" property (part of a name or email address), using dynamic content or literal string etc. I'd also recommend setting subject filter etc for security reasons.

2. Do you mean that the report does not reflect new records in the browser until page is refreshed? That is normal behavior. There are ways to get around it. Ex: Use browser refresh extension. If that's not an option... you'll need data source that supports direct query mode and set auto page refresh. Note that SharePoint list does not support it. Otherwise, you'll just need to live with scheduled refresh interval configured in the data set.