Error trying to conect Power BI with TFS

[sandragocj27]

Hi every body, 

I'm trying to connect to TFS, here is my code for the edvanced editor:

let
GetWorkItemIds = () =>
let
Source = Json.Document(Web.Contents("https://XXXXXX.visualstudio.com/XXXXXX/_apis/wit/wiql/a722b515-98b6-4bf7-b4a9-102c9aca1b8a")),
workItems = Source[workItems],
#"Converted to Table" = Table.FromList(workItems, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expand Ids" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id"}, {"Work Item Id"})
in
#"Expand Ids"
in
GetWorkItemIds

With this code I get a function, but when I click to the "invoke" button, It appears the followin error:

Error inesperado en la consulta 'Consulta1'. DataFormat.Error: Se encontraron caracteres adicionales al final de la entrada JSON.
Detalles:
Value=
Position=4

Any idea?

Thanks and regards

[v-yuezhe-msft]

@sandragocj27,

I test your function using my own JSON file, and everything works well. In your scenairo, do you get any error message when directly paste the following M codes into advanced editor of a new blank query?

let
Source = Json.Document(Web.Contents("https://XXXXXX.visualstudio.com/XXXXXX/_apis/wit/wiql/a722b515-98b6-4bf7-b4a9-102c9aca1b8a")),
workItems = Source[workItems],
#"Converted to Table" = Table.FromList(workItems, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expand Ids" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id"}, {"Work Item Id"})
in
#"Expand Ids"

Regards,
Lydia

[sandragocj27]

This is the error I get:

Error inesperado en la consulta 'Consulta1'. DataFormat.Error: Se encontraron caracteres adicionales al final de la entrada JSON.
Detalles:
Value=
Position=4

[v-yuezhe-msft]

@sandragocj27,

It seems that there are extra characters in the JSON file that returned by TFS, please check my reply in this similar thread.

Regards,
Lydia