It sounds like you're hitting a classic issue with Power BI alerts. That “response is not in JSON format” error usually happens because the Power BI connection has flickered, likely due to an expired token, an MFA prompt, or the dashboard tile being edited. When that happens, Power Automate gets an HTML "Please Sign In" page instead of the data it needs, which is why it complains about the format.
For a reminder scenario, a Power BI alert is actually quite fragile. A much more stable "Architect-approved" approach is to flip the logic:
- Trigger: Use a Recurrence trigger (e.g., every weekday at 9 AM).
- Action: Query your "Source of Truth" directly (whether that’s Dataverse, SQL, or SharePoint).
- Condition: Check if the count of pending items is > 0.
- Action: Send your Outlook email if the condition is met.
This is way more reliable because it cuts out the middleman (Power BI service). Power BI alerts are great for "one-off" threshold events, but for operational reminders, a scheduled flow hitting the data directly is the way to go.
If you really need to stick with the Power BI alert for now, you’ll need to delete and recreate the Power BI connection in the flow and double-check that the alert owner is still active. But honestly, moving to a scheduled flow will save you a lot of maintenance headache in the long run.
If you can share what your actual data source is (SQL, SharePoint, etc.), I can give you the exact query to use for step 2!
✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.
