Hey everyone, I’m stuck with a PowerBI issue. I made this cool dashboard that pulls data straight from Jira using an API and JQL queries. It’s great on my computer. I hit refresh and boom, it’s all there.
But here’s the thing. Once I put it online, it’s like the refresh button vanishes. Can’t do it by hand, can’t set it up to happen on its own. Weird, right?
I’m not looking to buy anything from the marketplace to fix this. And getting a gateway set up? That’s a whole other headache with my company.
I tried a workaround where I exported the data to a SharePoint folder. That actually worked for refreshing. So it seems the problem is when I’m trying to pull directly from Jira.
Any ideas on how to get this working without too much fuss? Thanks!
hey, i had this issue too. try using gogle sheets to grab jira data automaticly. connect powerbi to the sheet. it ain’t perfect but works for me. could be a simpler fix than a full gateway setup.
I’ve faced a similar challenge with Jira data in PowerBI. Here’s what worked for me:
Instead of pulling directly from Jira, I set up a scheduled task on a server to export the Jira data to a CSV file in a shared location. Then, I configured PowerBI to read from this CSV file instead of the Jira API.
The task runs daily, updating the CSV with fresh Jira data. PowerBI then refreshes from this file automatically. It’s not real-time, but it’s a good compromise that doesn’t require gateways or expensive add-ons.
You might need IT help to set up the task, but it’s a one-time thing. After that, it’s hands-off and works reliably. Just make sure your Jira credentials are stored securely if you’re using them in the export script.
This approach has been running smoothly for us for months now. Hope this helps!
I encountered a similar issue and found a workaround that might help. Instead of direct Jira integration, consider using Power Automate (formerly Microsoft Flow) to create a scheduled flow. This flow can extract data from Jira and store it in a SharePoint list or Excel file on OneDrive.
Then, configure your Power BI dashboard to pull data from this SharePoint list or Excel file. Power BI can refresh data from these sources automatically when published online.
This method doesn’t require additional purchases or complex gateway setups. It leverages existing Microsoft 365 tools, assuming your organization uses them. The flow can run at your preferred frequency, ensuring your dashboard data stays current.
While it’s not real-time, it provides a good balance between data freshness and system complexity. It’s been reliable in my experience, requiring minimal maintenance once set up.