Not able to connect Jira to PowerBI

[connde]

Hi, I used to have Jira integrated to PowerBI and used it a couple of years ago, now I'm trying to use it again and some errors are popping up.

I get same error using from Power BI Cloud or Desktop.

For desktop, I used instruction here https://community.atlassian.com/t5/Marketplace-Apps-questions/All-data-not-displayed-in-Power-BI-fro... 

I managed to solve authentication issue in desktop by passing the header manually, using this piece of code

let

options = [Headers =[#"Content-type"="application/json",
#"Authorization"= "Basic CODEHERExxtLmNvbTpKdXJlbWE0MjAh"]],

But then I got new error. If I put this URL in browser it works as it should and I get all information

 This is what Fiddle returns to me related to above error

{"errorMessages":["The value 'UAFU' does not exist for the field 'project'."],"warningMessages":[]}

Does anyone experiencing same situation in present day?

I also posted this in Jira, but it seems to be related to PowerBI as I cannot connect neither by using Services in Power BI cloud neither in Desktop, althought I was able to solve authentication issue in Desktop with above workaround other errors appears.

All URLs generated by PowerBI works if I input then directly to the browser.

Power BI Version: 2.68.5432.841 64-bit (abril de 2019)

Thanks in advance.

[antonstorozhuk]

Hello @connde 

I’d like to propose and alternative solution for you, you might want to try out our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie... it's available for Jira Cloud / Server / Data Center.

We have a handy User/Admin Guide https://aserve.atlassian.net/wiki/spaces/PBCFJC/overview and fast/responsive support team at support@alpha-serve.com. Please let us know if you need any assistance.

Cheers!

Anton

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