OLE DB or ODBC error: [Data.Source.Error] AND TRUE ^ ERROR unexpected token: 'TRUE'

[Anonymous]

Please help with the error below:

[Greg_Deckler]

Sort of looks like an error in a SQL query perhaps. Are you pasting in some SQL code or something when connecting to the data source?

[Anonymous]

Yes. Do you know what the token is?

[v-juanli-msft]

Hi @Anonymous 

As searched, token means:

1) In programming languages, a single element of a programming language. For example, a token could be a keyword, an operator, or a punctuation mark.

(2) In networking, a token is a special series of bits that travels around a token-ring network. As the token circulates, computers attached to the network can capture it. The token acts like a ticket, enabling its owner to send a message across the network. There is only one token for each network, so there is no possibility that two computers will attempt to transmit messages at the same time.

(3) In security systems, a small device the size of a credit card that displays a constantly changing ID code. A user first enters a password and then the card displays an ID that can be used to log into a network. Typically, the IDs change every 5 minutes or so.

In your case, there may be error for authentication acess token or code in Advanced editor.

To look into this problem, please provide more details, like:

What is your data source, how do you authenticate the data source with power bi,

What is your code in Advanced editor, which step causes this error,

What is in the "row1 column713"?

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.