Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Trying to pull information off of Jira for the web. Looks like Atlasian no longer does user id/password authentication - all of the answers I found seem to be either older and using that method or incomplete.
What I understand - a token must be generated in base64 that combines user email and api token from Jira. I do that with this code
let
Source = User&":"&Token,
Bytes = Text.ToBinary(Source),
TextForm = Binary.ToText(Bytes, BinaryEncoding.Base64 )
in
TextForm
Then I execute the API with this (that I just pulled from another thread)
let
BaseUrl = "https://titanpm.atlassian.net/rest/api/3/search?jql=project in ('Titan Solutions')",
JiraIDPerPage = 1000,
GetJson = (Url) =>
let
RawData = Web.Contents(Url,[Headers=[Authorization="Basic " & Credentials ]]),
Json = Json.Document(RawData)
in Json,
GetJiraIDCount = () =>
let Url = BaseUrl & "&maxResults=0",
Json = GetJson(Url),
Count = Json[#"total"]
in Count,
GetPage = (Index) =>
let Skip = "&startAt=" & Text.From(Index * JiraIDPerPage),
Top = "&maxResults=" & Text.From(JiraIDPerPage),
Url = BaseUrl & Skip & Top,
Json = GetJson(Url),
Value = Json[#"issues"]
in Value,
JiraIDCount = List.Max({ JiraIDPerPage, GetJiraIDCount() }),
PageCount = Number.RoundUp(JiraIDCount / JiraIDPerPage),
PageIndices = { 0 .. PageCount - 1 },
Pages = List.Transform(PageIndices, each GetPage(_)),
JiraID = List.Union(Pages),
Table = Table.FromList(JiraID, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(Table, "Column1", {"id", "key", "fields"}, {"Column1.id", "Column1.key", "Column1.fields"})
in
#"Expanded Column1"
The problem is credentials on the data source itself. Power BI gives an error for anonymous access (with the key in the code)
I know I can't use user ID and password anymore? What should I be using to get through here???
Solved! Go to Solution.
Hi, @dude95
You can follow the steps of this blog:
Connecting Jira to Power BI: 3 Easy Steps
Step 1: Generate an API Token
Step 2: Download and Install the JIRA Content Pack
Step 3: Add the API Token to the Jira Power BI Content Pack
Now, you can use an API key (Manage API tokens for your Atlassian account ) instead of the password.
Link to deprecation notice: Deprecation notice - Basic authentication with passwords and cookie-based authentication
Here are some references:
Guide:
How to Set up a Power BI Jira Integration: The Complete 2021 Guide
Threads:
Connecting Jira to Power BI using the Web API
Manage API tokens:
Manage API tokens for your Atlassian account
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @dude95
You can follow the steps of this blog:
Connecting Jira to Power BI: 3 Easy Steps
Step 1: Generate an API Token
Step 2: Download and Install the JIRA Content Pack
Step 3: Add the API Token to the Jira Power BI Content Pack
Now, you can use an API key (Manage API tokens for your Atlassian account ) instead of the password.
Link to deprecation notice: Deprecation notice - Basic authentication with passwords and cookie-based authentication
Here are some references:
Guide:
How to Set up a Power BI Jira Integration: The Complete 2021 Guide
Threads:
Connecting Jira to Power BI using the Web API
Manage API tokens:
Manage API tokens for your Atlassian account
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |