3 ms·
My manager a few jobs back did something like this, but just using Microsoft Excel with Power Query. No need to even install sqlite. Normally, that probably isn
by nonameiguess 4y ago
My manager a few jobs back did something like this, but just using Microsoft Excel with Power Query. No need to even install sqlite. Normally, that probably isn't much of an obstacle, but this was in a classified environment where it was nearly impossible to get the local IT admins to install additional software on your workstation. Every corporate Microsoft box is going to already have the Office suite.
- crestfallen 4y agoI'm curious about this. I would say I'm fairly versed in Excel but haven't dug too deep into Power Query / the data model. If you wouldn't mind, how is this done?
- ako 4y agoLooks like it's documented on the atlassian website: https://community.atlassian.com/t5/Jira-Core-Server-questions/Import-JIRA-REST-API-results-to-Excel-Web-Power-Query/qaq-p/1083354 https://community.atlassian.com/t5/Jira-Core-Server-question...
- crestfallen 4y agoI didn't get back to this in a timely manner but I wanted to thank you.