Retrieve Jira export file

[Anonymous]

Hi All,

I have a Jira URL that successfully retrieves and downloads an export file:

https://jira.compABC.com/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.csv?jqlQ...

I want to use it as a source for a table.  I have tried quite a few variants to no avail.  Such as:

let
    Source = Csv.Document(
        Web.Contents("https://jira.compABC.com/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.csv?jqlQ..."),

            [Delimiter=",", Columns=252, Encoding=1252, QuoteStyle=QuoteStyle.Csv])
in
    Source

Looking for a native solution without the use of a connector.

Any thoughts?

Cheers, Steve

[StevenDavidson]

I know the question has been solved, but I'm curious about the use case here. Were you looking to apply transformations to the data or something else? I'm wondering whether Get and Transform in Excel could do some of what you might need (dropping columns, cleansing data for import, etc.) or if using another data prep tool like R might be more appropriate. 

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

There used to be a Power BI content pack for JIRA to perform this function. However, this app is no longer available on the Power BI app marketplace. Nonetheless, you can download the .pbit version to use in Power BI Desktop.

Here is the link.Connecting Jira to Power BI: Easy Steps - Learn | Hevo (hevodata.com)

Then follow the steps to create a token and add a connection in the content pack.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You have JIRA app, if that can help

https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/

or custom connectors from partners

https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie...

https://marketplace.atlassian.com/apps/1219072/power-bi-connector-pro-for-jira?hosting=cloud&tab=ove...

[Anonymous]

My understanding is that the Jira content pack is no longer available.

Is it still available somewhere? Link?