Need ADO data by using API through Power Query

Sonata27 · ‎06-11-2021

Hello,

I need to load data from ADO by using API through Power Query. The script is below, but it shows an error:

"DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value=
Position=4"
Any help would be appreciated.

mahoneypat · ‎06-11-2021

Did you try it with wrapping 0 and 300 in "" "" also?

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources