ODB Connection error

[pwprince]

Hi Riazraza,

Very useful project. Thank you.

I am not able to connect to my Jira instance when opening the template. I get an OLE DB or ODBCerror: [DataSource.Error] Web.Contents failed to get contents from 'https://fscedge.atlassian.net/rest/api/3/search?jql=project%20IN%20%28JPPS%29&maxResults=100&startAt=0&fields=%2Aall' (400): Bad Request.

I've generated the api token. Any thoughts?

Thanks!
Patrick

[tdalon]

Have you configured in PowerBI how you connect to the Data or just generated the token and did nothing with it?

To setup the connection parameters, go to Home->Transform Data->Data source settings
Select the first only entry and Edit Permissions
Use as Password the API Token