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

[Barak Bester]

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="