dataformat.error

[Rjones2021]

Powerbi desktop issue:

From my Apps query when i try to apply it in query editor it downloads several MB but then i get the following error.

"ole db or obdc error:[dataformat.error] [dataformat.error] We found an unexpected character in the JSON input.."

It happens when i expand the "ManagedDevices" column and try to select anything and apply.  I've tried making that column into text but still get the same error.  I've tried pulling from "beta" and "v1.0" with same results.

I'm pulling data from Intune using a delegated graph connector.  If i don't expand any columns i'm able to "apply" and it finishes.

From advanced editor:

let
Source = DelegatedScopeGraphConnector.Contents("removed", "removed", "removed", "v1.0/devicemanagement/detectedapps"),
#"Expanded managedDevices" = Table.ExpandTableColumn(Source, "managedDevices", {"deviceName"}, {"deviceName"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded managedDevices",{{"deviceName", type text}})
in
#"Changed Type"

 Updating Media

[Anonymous]

Hi @Rjones2021 ,

There is a similar case that you could refer: We found extra characters at the end of JSON input... - Microsoft Power BI Community

Please try below options:

Deleted the optional encoding parameter (I had it set at 1200) within the Json.Document function. That solved the error.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rjones2021]

I'm not seeing where i would put that?