- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,ProjectSK,CycleTimeDays,ChangedDate,ChangedDateSK,TagNames,CompletedDateSK,CompletedDate
The problem is, some projects contain the blocked column in the data table, some do not. I want to have one query I can use regardless of project, albeit I want to just bring in the necessary columns rather than them all.
Anyone have any advice?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@FlowViz
Try add a query step to your code, for example:
#"Column"=Table.SelectColumns(Users_table,{"ID","Date","Type","Amount"})
in
#"Column"
Best regards
Paul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks - 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),
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@FlowViz
Try add a query step to your code, for example:
#"Column"=Table.SelectColumns(Users_table,{"ID","Date","Type","Amount"})
in
#"Column"
Best regards
Paul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks - 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),
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you get an error when you make a call with the Blocked column in the $select but it doesn't exist for that project, you could use try ... otherwise ... and check first with the Blocked version otherwise use the one w/o it. Multiple web calls in some cases, but it should work.
Pat
Did I answer your question? Mark my post as a solution! Kudos are also appreciated!
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypa HoosierBI on YouTube
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Previously I've used
https://analytics.dev.azure.com/{Organization}/{Project}/_odata/v3.0-preview/WorkItemRevisions?
And brought in all columns then used MissingField.UseNull to filter...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you bring in the query name vs having the columns listed in the URL like that?
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHelpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
11-08-2023 06:15 AM | |||
Anonymous
| 02-06-2023 08:00 AM | ||
03-18-2024 10:14 AM | |||
Anonymous
| 06-29-2023 06:04 AM | ||
04-05-2024 02:58 AM |