I'm trying to connect to my local Jira from power BI with the web option, putting the base url of Jira, entering the same access credentials that I use when I log in via web, but it always generates the error: "The credential provider are invalid". However if I create a query apart from 0 in the advanced editor putting what I initiate below if it connects, why web I can't?
let
BaseUrl = " https://jira-xxxxx.com",
JiraIDPerPage = 100,
GetJson = (Url) =>
let
RawData = Url,
Json = Json.Document(RawData)
in Json,
GetJiraIDCount = () =>
let Url = Web.Contents(BaseUrl, [RelativePath="/rest/api/2/search", Query=[jql = "project in ('PSCO') ",maxResults = "0"]]),
Json = GetJson(Url),
Count = Json[#"total"]
in Count,
GetPage = (Index) =>
let
Url = Web.Contents(BaseUrl, [RelativePath="/rest/api/2/search", Query=[jql = "project in ('PSCO') ",startAt=Text.From(Index * JiraIDPerPage), maxResults = Text.From(JiraIDPerPage)]]),
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)
in
Table
