New column at source (dynamic 365 online) does not include in power bi after refreshing

[rickylee]

Hello,

New column at source (dynamic 365 online) does not include in power bi after refreshing. I have seen various posts inlcuding edit queries and advanced editor:
https://community.powerbi.com/t5/Service/New-column-in-source-table-not-appearing-in-dataset-after/m...

It seems my problem has not be solved.

The code in my advanced editor looks like this and I cannot see a definition to define the number of columns:

let
Source = OData.Feed("https://chasprod.api.crm4.dynamics.com/api/data/v8.2/", null, [Implementation="2.0"]),
salesorders_table = Source{[Name="salesorders",Signature="table"]}[Data],
#"Reordered Columns" = Table.ReorderColumns(salesorders_table,{"_pricelevelid_value", "salesorderid", "name", "createdon"}),
#"Removed Columns" = Table.RemoveColumns(#"Reordered Columns",{"lastbackofficesubmit"})
in
#"Removed Columns"

Thanks,
Ricky

[marclelijveld]

Hi @rickylee, 

Not sure, but possibly this happends in your reordered columns step. Can you check if every column you want as output is specified in the reordered step. 

Beside that, did you try to create a new query in Power BI desktop to this source already? Is the column still missing in that case? 

- Marc