Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Steven Myers]

Hi All,
I just started receiving the below error on multiple tables yesterday.  This is not occurring on all the tables used by the connection. 

DataSource.Error: Microsoft SQL: JSON text is not properly formatted. Unexpected character ‘.’ is found at position 0.
Details:
DataSourceKind=SQL
DataSourcePath=removed for security reasons. 
Message=JSON text is not properly formatted. Unexpected character ‘.’ is found at position 0.
ErrorCode=-2146232060
Number=13609

——————————
Steven Myers
BI Manager
Delachaux Group
——————————

[Jeremy Dennis]

Seems like this will have to be corrected at the database level.  Issue a SQL query to those tables producing the error to find the rows with a JSON columns that have a ‘.’ and that were also recently added.  Inspect and see if those ‘.’ can be removed and why they were inserted/updated that way in the first place in order to avoid future occurrences.

Good luck, Steven. 

Kind regards,

-J

——————————
Jeremy Dennis
Director of Analytics
——————————
——————————————-