Hey everyone,
I’ve got a Power BI dashboard with a card showing the count of table names. I’m trying to figure out how to set up an automated system that creates a Jira ticket whenever this count goes over 10.
Has anyone done something similar before? I’m not sure where to start with this. Should I use Power Automate or some other tool to connect Power BI with Jira?
Also, I’m wondering if there’s a way to include the specific table names in the Jira ticket description when it’s created. That would be super helpful for our team to track which tables are causing the count to go up.
Any tips or suggestions would be really appreciated. Thanks in advance!
yo, i’ve done smthing similar using zapier. it’s pretty easy to setup. just connect ur power bi to zapier, set a trigger for when the count hits 10+, then link that to jira. u can even grab the table names and chuck em in the ticket description. works like a charm for us. give it a shot!
I’ve actually implemented something similar in my organization, and it’s been a game-changer for our workflow. We used Power Automate (formerly Flow) to connect Power BI with Jira, and it works seamlessly.
Here’s what we did:
First, we set up a Power BI data alert on the card showing the count. This triggers when the count exceeds 10.
Then, we created a Flow in Power Automate that listens for this alert. When triggered, it pulls the necessary data from Power BI, including the specific table names.
Finally, the Flow creates a Jira ticket using Jira’s REST API, populating it with the relevant information.
One thing to watch out for: make sure your Power BI refresh schedule aligns with your team’s needs. We initially had issues with delayed tickets because our dataset wasn’t refreshing frequently enough.
Also, consider setting up a cooldown period to prevent duplicate tickets if the count fluctuates around the threshold. This saved us from ticket spam on a few occasions.
Hope this helps point you in the right direction!
I’ve found a reliable solution for this using Azure Logic Apps. It’s quite straightforward to set up and offers excellent integration capabilities.
First, create a scheduled trigger in Logic Apps to run at your desired frequency. Then, use the Power BI connector to query your dashboard data. You can easily extract the card count and table names here.
Next, add a condition to check if the count exceeds 10. If true, use the Jira connector to create a new ticket. You can populate the ticket description with the table names you extracted earlier.
One tip: consider implementing error handling and logging. It’s been invaluable for troubleshooting and maintaining our automation.
This approach has been rock-solid for us, with minimal maintenance required once set up. It’s definitely worth exploring if you’re looking for a robust, scalable solution.