Forum Discussion

jesus_heredero1's avatar
jesus_heredero1
Frequent Visitor
6 years ago

Refresh Error We found extra characters at the end of JSON input..

when I work in Power bi desktop  it works perfectly,  but when I publish in server and refresh,  this error is return:   Error del origen de datos: We found extra characters at the end of JSON inpu...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi jesus_heredero1 

How about this working on your side?

contents = Web.Contents(URL,
            [
              RelativePath= "/rest/agile/1.0/board/1779/issue?
fields=components,parent,resolution,reporter,assignee,customfield_11023,created,status,fixVersions,timetracking,customfield_11100,resolutiondate,issuetype,labels,customfield_10758,summary,worklog,priority,updated,customfield_11119&jql=project in (EEDS, PS2PD) and updated >= -120d,
             Query = [maxResults= Text.From(pageSize), startAt = Text.From(skipRows)]
            ]
),
json = Json.Document(contents),
Value = json[issues],
table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jesus_heredero1's avatar
jesus_heredero1
Frequent Visitor
6 years ago

thanks you Maaggie, but I have had the same return

 

  • Error del origen de datosWe found extra characters at the end of JSON input.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: GetIssues.
  • URI de clústerWABI-EUROPE-NORTH-B-redirect.analysis.windows.net
  • Identificador de actividad69903e12-b96e-4107-801b-fcd6d907b11e
  • Identificador de la solicitud0e9fa7ce-2d10-2d36-86ba-994f2752a47f
  • Hora2020-05-19 15:14:42Z

This time the duration of the refresh was longer.