Querying Jira REST from Power BI Yields 0 results directly, but 8 if saved to file

Barak Bester_2djlb8

Direct Access:

I defined an API Token

In Power BI, I used

Source = Json.Document(Web.Contents("<MyJiraServer>/rest/api/2/search?jql=issuetype=Epic",[ApiKeyName=<MyAPIToken>]))

In datasource setting I gave the API Key

The result was a blank table. 

In Direct Access:

I typed <MyJiraServer>/rest/api/2/search?jql=issuetype=Epic in browser.

I copied the result to notepad and saved it

In Power BI I chose to connect to JSON and chose the file I saved

The result was a list of 8 issues

Why does direct access bring blank tables?

Rudy Holtkamp

Hi, probably with BI you don't have the correct authentication. In your browser you are already logged in. Try to do the same on the command line with curl.

Use <yourusername>:<yourapitoken> and encode it Base64.

E.g: PHlvdXJ1c2VybmFtZT46PHlvdXJhcGl0b2tlbj4= then use as header

-H "Authorization: Basic PHlvdXJ1c2VybmFtZT46PHlvdXJhcGl0b2tlbj4="