Forum Discussion

Power2BI's avatar
Power2BI
Icon for Helper I rankHelper I
1 year ago

Power BI Couldn't Refresh online - But Refresh properly in Desktop (Mashup.ErrorCode = 10224)

Hello Community,   Power BI Couldn't Refresh online in the workspace - But Refresh properly in Desktop as in below error message (couldnt find the column name):   Data source error: Expression.E...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Power2BI ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

 

Power2BI's avatar
Power2BI
Icon for Helper I rankHelper I
1 year ago

Unfortunatly still didnt work! This make me crazy as all configured well and working desktop app perfectly. Last attempt to change the code and get no errors with no result :S

let
// --- Step 1: Define Jira API connection parameters ---
JiraDomain = "SERVERNAME",
JqlQuery = "project=PROJECTNAME",

// --- Step 3: Define the recursive function for pagination ---
fnGetAllJiraIssues = (optional nextPageToken as text) as list =>
let
QueryOptions = [
jql = JqlQuery,
fields = "*all",
maxResults = "100" // Use maxResults parameter in the query options
] & (if nextPageToken <> null then [nextPageToken = nextPageToken] else []),
Source = Web.Contents(
"https://" & JiraDomain & ".atlassian.net",
[
RelativePath = "/rest/api/3/search/jql?",
Query = QueryOptions,
Headers = [
Accept = "application/json"
]
]
),
Json = Json.Document(Source),
Issues = Json[issues],
IsLastPage = Json[#"isLast"],
NextPageToken = if IsLastPage = false then Json[#"nextPageToken"] else null,
NextPageIssues = if NextPageToken <> null then @fnGetAllJiraIssues(NextPageToken) else {},
AllIssues = Issues & NextPageIssues
in
AllIssues,

// --- Step 4: Get all issues using the custom function ---
AllIssuesList = fnGetAllJiraIssues(),
#"Expanded Issues" =
Table.ExpandRecordColumn(
Table.FromList(AllIssuesList, Splitter.SplitByNothing(), {"Issue"}, null, ExtraValues.Error),
"Issue",
{"id", "self", "key", "fields"},
{"id", "self", "key", "fields"}
)
in
#"Expanded Issues"

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Power2BI ,
    Thank you for sharing the updated query. Since it functions correctly in Desktop but not in Service, please consider the following troubleshooting steps:

    Re-enter credentials in Service: Navigate to Workspace - Dataset - Settings - Data source credentials. Use Basic Auth with your email address and API token. Note that Desktop may use cached credentials, while Service requires new authentication. Review Gateway configuration: If Jira is on-premises, Service will need a Gateway to access it. Set up an On-Prem Gateway and link your dataset accordingly. Update the Web.Contents call: Rather than combining RelativePath and Query, construct the URL directly as follows:
    Source = Web.Contents("https://" & JiraDomain & ".atlassian.net/rest/api/3/search?" & Uri.BuildQueryString(QueryOptions), [Headers = [Accept = "application/json"]])

    Adjust pagination fields: The Jira /search API uses startAt, maxResults, and total instead of isLast or nextPageToken. Please update your recursive function to reflect this.
    If these steps don't resolve the issue and Service still shows no data, please submit a Support ticket with Microsoft so they can review your Service environment logs and identify if the issue is with Power BI Service or Jira API limits. To create a ticket, follow this guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      11 months ago

      Hi Power2BI ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        11 months ago

        Hi Power2BI ,
        I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions