I am trying to query Jira REST API from PowerBI and was successful on PowerBI desktop. The issue is that this particular Jira is not using corporate ID, so I had to use "Basic" authentication. I managed to get it working on desktop using both
Data source settings - Basic auth
and Anonymous auth and Power Query language - options = [Headers =[#"Authorization"="Basic abcdefghijklmno123456"]]
But no matter what I do, the data source is not refreshing after I published it to the portal.
When I try to refresh it online it says:
The way it looks it seems to me your cluster is trying to access Jira from outside the firewall, which is impossible without VPN.
I assumed that was why you have your Gateway, but "Gateway connection" options says
You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect. Learn more
This leaves me with no other options than to ask here... 🙂