DataSource.Error: ERROR [HY000] [Microsoft][DriverSupport] (2003) JSON parsing error: Invalid value.

[Tani4ka]

Hi there,

I'm running into this isse when try to connect to QBG specific view

I can load any other view's data in Power bi not this one. The view is created by me and works in GBQ (returns correct resutls).

Any idea why I can't connect to it?

I've restet source settings credentials (deleted and reset) and still no luck.

Many thanks,

T

[JDro]

Anyone else coming across this thread, check your table / view name to ensure it doesn't have any spaces or symbols that would throw this error.

[Tani4ka]

I deleted that view and recreated it again and it solved the problem , so still not sure what it was.

[amitchandak]

@Tani4ka , open power query and check of there more specific error, seem like json is not getting correct value