notify user for long running queries

[powerbiexpert22]

is there a way to notify admin  or any user in case if report is taking too long to run or direct query is taking to long 

or if fabric warehouse is taking too long to run?

[v-pagayam-msft]

Hi @powerbiexpert22 ,

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance. If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.

Regards,
Pallavi.

[v-pagayam-msft]

Hi @powerbiexpert22 ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.

[grazitti_sapna]

Hi @powerbiexpert22 

Yes, it's possible to create notifications for slow-running reports, DirectQuery interactions, or Fabric Warehouse queries using Power Automate. You can monitor the performance of these processes and trigger notifications to admins or other users when performance thresholds are exceeded

Create a Power Automate Flow:

• Trigger: Use a trigger based on a scheduled event (e.g., a daily or hourly check) or a specific event like a report refresh or a query completion. 
  
• Actions:
  
• Check Performance Metrics: Use a Power Automate action to access the Performance Analyzer data, Query Insights, or Flow Analytics data to retrieve execution times. 
  
• Compare with Thresholds: Compare the execution times to your defined performance thresholds. 
  
• Send Notifications: If the threshold is exceeded, use Power Automate actions to send email, SMS, or other notifications to admins or users.
  
  Also, Please find the below blog
  https://www.wiseowl.co.uk/power-automate/blogs/power-automate-cloud/flows/power-bi-alert-using-power...
  
  

  🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

  💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

  🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

  🔗 Curious to explore more? [Discover here].

  Let’s keep building smarter solutions together!

  
  

[pankajnamekar25 · Accepted solution]

Hello @powerbiexpert22 

Explore this blog

Sending alerts from Fabric Workspace Monitoring using KQL Querysets and Activator

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.