Retrieving html instead of table from Jira filter using Power Query

[Vinicius Medina]

Hi,

I have a lot of copy and paste work to prepare some reports in Excel. I have few filters in Jira where I export custom fields to .csv and paste on Excel. Not efficient at all.

I tried to use Excel Power Query > Get from Web and used the link from Jira that was generated when .csv export button was pressed, hence I had the link[bla bla bla]=delimiter, [which is the link from .csv file when I go to "Get address link". I'm currently login in with my company Windows credentials and it worked perfectly! Well, until two weeks ago. When I started to use [~ 2 months ago] it was showing the table properly, I even created few custom columns.

But all of sudden since two weeks ago, when I pressed "refreshed" I got an error message saying "Issue type can't be found" (which was one of the columns from that filter. When I went to the data source settings > source (first step from Power Query), I noticed that instead of the usual table, Excel was pulling html content from the filter, hence of course "Issue type" was not there, so it couldn't proceed to promote headers and the whole thing was broken.

I contacted my company support and they said nothing was changed on Jira (configuratin-wise) and also nothing was changed in my filter (because I'm the only editor).

Do you have any clue on what could've happend and more important: is there any way to fix it?

Thanks in advance!

Vini

[Vinicius Medina · Accepted solution]

Hi @KD - Ricksoft and @Tomislav Tobijas , thanks for your time and the answers!

For the things you mentioned I have to check if they are available / allowed.

Turns out I found the issue and it was a very silly one. I was authenticating with Windows Credentials on Excel and it was working fine, as mentioned it stopped working out of sudden with this html thing. I changed to Basic Authentication on Excel and put my Windows credentials and it worked :S

But definitely I will have a look on those you mentioned!

[KD - Ricksoft]

Hey ya Vini,

It seems to be an atlassian issue,

But if you’ve got a separate Confluence instance, we’ve got a feature in Excel-like Tables for Confluence called Jira Issue Sheets. It lets you pull data straight from any Jira instance, so your reports stay updated without all the manual work.

With it, you can:

• Connect to multiple Jira instances and pull issue data.

• Set filters to auto-refresh whenever you open the page.

• Tweak your JQL queries, filters, or columns anytime.

• Use spreadsheet-style functions and charts right inside Confluence.

Here’s the doc if you want to take a look:
Jira Issue Sheets

And if you hit any bumps, our support team’s always there to help.

It’s free for up to 10 users, so you can give it a spin and see if it works for you.

KD

[Tomislav Tobijas]

Huh, might be best to try to contact Atlassian Support about this @Vinicius Medina 👀

A question—have you tried using this official app: Jira Cloud for Excel (official) 
It's basically an add-on within Excel that pulls items from Jira with just one click. You can use saved filters or write JQL within the app directly, and also state which data (columns) you'd like to pull.
I'm using it from time to time and it's quite nice if you need to manipulate Jira data further in tools such as Excel 🙂