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
Shubham_rai955's avatar
Shubham_rai955
Icon for Super User rankSuper User
1 year ago

Power2BI This error usually happens when Power BI Service attempts to expand a column ("Column1") that was automatically generated in Desktop, but the online refresh can't find it, often due to a change in the source data shape or how Power Query handles JSON from Web.Contents. To resolve:

  • Check the source JSON live in Power BI Service: confirm that "Column1" exists after Table.FromList, sometimes the returned structure changes between desktop and cloud.

  • Use explicit column naming in Table.FromList: set the column name (e.g. {"IssueRecord"}) when converting from list, then reference it accordingly in Table.ExpandRecordColumn.

  • Preview and validate each query step in Power Query, especially after Web.Contents, to catch missing or renamed columns before publishing.

  • If possible, debug with sample data from the actual service endpoint, as column structures can shift due to API pagination or schema differences on refresh.

Making column names explicit and confirming the API's response format are key for consistent refresh across Desktop and Service

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"