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/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

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      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

        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