Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power Query giving error while importing certain OData feeds from azure devops

Hi Team, I need urgent help.I want to build team velocity chart in power bi from azure devops data.Planned workitems verses Completed workitems. I am using odata feed for getting workitemrevision da...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-Kalyj,

I have removed the OmitValues = ODataOmitValues.Nulls.  And query looks like below:

= OData.Feed("https://analytics.dev.azure.com/Organization/project/_odata/v3.0-preview/WorkItemRevisions?$filter= WorkItemType in ('User Story')
&$select=WorkItemId,Title,WorkItemType,Revision,RevisedDate,IsCurrent,IsLastRevisionOfDay,State,StateCategory,StoryPoints,Priority,Severity,TagNames,AreaSK
,CycleTimeDays,LeadTimeDays,InProgressDate,CompletedDateSK,CompletedDate,StartDate,NT_Test_DefectType
&$expand=AssignedTo($select=UserName),Area($select=AreaPath),Iteration($select=IterationPath),Project($select=ProjectName),
)
",
null, [Implementation="2.0"])

 

 

But after that i am getting error as 

DataSource.Error: OData: A null value was found for the property named 'AreaPath', which has the expected type 'Edm.String[Nullable=False]'. The expected type 'Edm.String[Nullable=False]' does not allow null values.
Details:
DataSourceKind=OData
DataSourcePath=https://analytics.dev.azure.com/Organization/project/_odata/v3.0-preview/WorkItemRevisions

 

 

 

Thanks,

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Anonymous ,

As the error suggests, it must have returned a null value in a column which claimed does not allow nulls. Can you change the "Edm.String[Nullable=False" to Ture, or remove the column, or put a filter on the query not to retrieve null values?

Or refer to this document to have a try: How to handle ‘A null value was found for the property’ exception

 

Best Regards,
Community Support Team _ kalyj