Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Tani4ka
Helper I
Helper I

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

 

Tani4ka_0-1633425863209.png

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

 

 

3 REPLIES 3
JDro
Helper I
Helper I

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
Helper I
Helper I

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

amitchandak
Super User
Super User

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.