Refresh Web.Contents JSON only refresh rows but do not update new columns

[mandynguyen]

I get data from a JSON query of the Slate Technolution database into Power BI using Web.

When I updated the query in Slate (adding new columns and adding filters to limit fewer rows) and refresh it in Power BI, it refreshes the rows (retrieved fewer rows), but the number of columns stays the same, did not add more.

[v-kkf-msft · Accepted solution]

Hi @mandynguyen ,

I think the problem is with the #"Expanded row1" (Table.ExpandRecordColumn) step. In this step we need to manually specify the columns that need to be expanded, which will result in the new columns in the data source not being selected.

You need to go to step #"Expanded row1" and select the new column (For example the cc field).

Or use the following code to expand the columns dynamically.

let
    Source = Table.FromRecords({
        [
            a = [aa = 1, bb = 2, cc = 3]
        ]
    }),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Record.FieldNames([a])),
    #"Expanded a" = Table.ExpandRecordColumn(Source, "a", List.Combine(#"Added Custom"[Custom]), List.Combine(#"Added Custom"[Custom]))
in
    #"Expanded a"

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mandynguyen]

Thank you! I manually check the new column and it worked!