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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors