Can't expand record or table after using odata connection to Azure devOps

[suzsword]

Hi

I have an oData feed to our Azure DevOps boards. I have managed to get the Source to wok, however when I try to expand the Record or the table I get an error. I can't figure out what is happening. 

I keep being drawn to doing the expand in the Source but I can;t get the syntax right. I have read through the microsoft documentation but it seems to be confusing me more than helping me.  

Can anyone help and let me know what I'm doing wrong? 

The details of the oData source, the result in Power Query, and the error displayed when I try to expand the Assigned To field are all attached.

Thanks

Susan

[stu1998]

Did you find a solution for this?  I am seeing the same issue. 

[poojayadav22]

did you get the solution ?

[dax]

Hi @suzsword , 

You could try to use expand in URL to see whether it work or not. You could refer to https://docs.microsoft.com/en-us/azure/devops/report/powerbi/create-quick-report-odataq?view=azure-d...  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.