Forum Discussion

Tani4ka's avatar
Tani4ka
Helper II
4 years ago

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

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

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

  • Tani4ka's avatar
    Tani4ka
    Helper II
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.