Can Power Automate Scheduled Dataset Query Alerts Be Used for Power BI Data Alerts?

manoj_0911 

Is this architecture backed by Microsoft for Production environments?

Yes, using Power Automate with "Run a query against a dataset" is a supported production model for custom Power BI alerts.

Are there any limitations on dataset query execution frequency when scheduled every 30 minutes?      

A 30-minute schedule is generally acceptable, subject to Power Automate, Power BI, and capacity throttling limits.

Are there dataset row count limitations when using "Run a query against a dataset"?        

Yes, practical limits exist, so queries should return only the minimum data required rather than large result sets, normally 100,000 per query and maximum.

Is Power Automate the recommended approach for report-based alerts where Power BI Data Alerts are unavailable?         

Yes, Power Automate is Microsoft's recommended solution for custom report-based alerting circumstances.

What licensing requirements apply (Power BI Pro/Premium/Fabric Capacity/Power Automate licensing)?        

Users need appropriate Power BI access (Pro or Premium/Fabric) and sufficient Power Automate licensing for the flow to run.

Are there any performance concerns if the dataset becomes large?       

Definitely, query performance may lower as dataset size increases, particularly if scanning large tables every 30 minutes interval.

Is there a better Microsoft-recommended approach for alerting users when new records meeting specific criteria appear in a Power BI dataset? 

For Fabric environments, New feature Data Activator is generally the best Microsoft solution for event-driven data alerts.That is applicable in your case.

If this helps, ✓ Mark as Kudos | Help Others
Proud to be a Fabirc SuperUser