Forum Discussion
Solved
OData query with missing column
Hey guys, I have a query I use for Azure DevOps: https://analytics.dev.azure.com/{Organization}/{Project}/_odata/v3.0-preview/WorkItemRevisions?$select=WorkItemId,Title,AreaSK,Blocked,Projec...
FlowViz
Try add a query step to your code, for example:#"Column"=Table.SelectColumns(Users_table,{"ID","Date","Type","Amount"}) in #"Column"Best regards
PaulThanks - this is what I think I'm using atm:
#"Removed Columns" = Table.SelectColumns(Source,{"WorkItemId", "AreaSK", "Blocked", "InProgressDate", "InProgressDateSK", "State", "TagNames","Title", "WorkItemType", "ChangedDate", "ProjectSK","StateCategory"}, MissingField.UseNull),
Can you bring in the query name vs having the columns listed in the URL like that?