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