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
Power2BI's avatar
Power2BI
Icon for Helper I rankHelper I
1 year ago

Also tried below code to change GetIssues Query, its working well in Power BI Desktop. However, no error in online / workspace refresh but no records or data retrived (

1sCompleted

😞

let
// Call the function to get all issues, which returns a list of records.
Source = fnGetAllJiraIssuesWithAllFields(),

// Use a pre-defined table type to enforce a consistent schema.
TableType = type table
[
id = text,
self = text,
key = text,
fields = record
],

// Convert the list of records to a table using the defined schema.
// The correct syntax is to directly use the variable name 'TableType'.
#"Converted to Table" = Table.FromRecords(Source, TableType)

in #"Converted to Table"

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Power2BI ,
    Thank you for providing the update and your revised query. Since it works on Desktop but returns no records in Service, this typically indicates a credential or connectivity issue between the two environments. Before making any code changes, please follow these steps:

    Navigate to "Workspace - Dataset - Settings - Data source credentials" and re-enter your Jira credentials (OAuth2 or API token). Desktop may use cached credentials, while Service requires a new authentication.

    If Jira is "on-premises", ensure you have configured an "On-Premises Data Gateway" and mapped the dataset accordingly. The Service cannot access your Jira source without a gateway.

    If these steps do not resolve the issue, you may proceed to:

    Update the query to use a "dynamic schema" (Record.ToTable) rather than a fixed schema to prevent mismatches when Service interprets the JSON differently.

    Test a basic query that returns the raw "JSON" response in Service to determine if the API is returning empty results or if there is a schema issue.

    Regards,
    Sreeteja

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