Forum Discussion

sandragocj27's avatar
sandragocj27
Frequent Visitor
8 years ago

Error trying to conect Power BI with TFS

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/XXXX...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
sandragocj27
Frequent Visitor
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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