I’m working with a Power BI dashboard that has a card showing the total number of database tables. Right now I’m manually checking this card every day to see if the count goes over 10. When it does, I have to manually create a Jira ticket to alert our team about this issue.
Is there a way to automate this process? I want the system to automatically create a Jira ticket whenever the card value shows more than 10 tables. I’ve looked into Power BI alerts but I’m not sure how to connect them to Jira for ticket creation.
Has anyone set up something similar before? What would be the best approach to link Power BI dashboard alerts with Jira ticket generation?
Been there multiple times. Manual checking sucks, especially with several dashboards to watch.
Power BI alerts do email fine, but getting them to create Jira tickets? That’s where everyone hits a wall. Power Automate might work, but the connections between Power BI, Power Automate, and Jira are unreliable.
I’d skip all that and use Latenode instead. Set it to check your Power BI data source on a schedule, evaluate your threshold, and auto-create Jira tickets when needed.
Best part? You’re not relying on Power BI’s alert system at all. Latenode hits your database or API directly, checks the table count, and if it’s over 10, creates a proper Jira ticket with all the details your team needs.
I built something similar for API response time monitoring. 30 minutes to set up, runs perfectly ever since.
Power Automate’s your best bet. Skip the dashboard alerts and set up a flow that monitors your Power BI dataset directly. Just create a scheduled flow that queries your data every few hours, checks if the table count hits your threshold, then fires off the Jira ticket via their REST API. I built something similar for server capacity monitoring last year - works like a charm. Getting the auth sorted between Power Automate and Jira takes a bit of fiddling, but once it’s running you’re golden. Pro tip: throw in some logic to stop duplicate tickets if your count stays above 10 for days.
zapier’s your best bet if you’re not super technical. it connects power bi to jira without the azure nightmare. i use it for the same thing - works perfectly once you nail the trigger setup. yeah, there’s a monthly fee, but it beats doing everything manually.
Azure Logic Apps + custom webhooks has been great for our infrastructure monitoring. Instead of constantly polling Power BI, I set up a webhook that fires when our data refresh finishes. The Logic App checks the threshold and creates Jira tickets via their API when something’s wrong. Way more efficient than scheduled checks - it only runs when data actually changes. Setting up the webhook takes some work in your data pipeline upfront, but it’s been solid once configured. We’ve run this for 8 months with no major problems. Best part is getting alerts almost instantly instead of waiting for the next scheduled check to catch threshold issues.