Microsoft Sql converting data type varchar(10) '___' to int only in powerbi?

[tahir9]

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Conversion failed when converting the varchar value '_____' to data type int..
'.

Hello i am getting this error but my query runs fine in SQL Management Studio not sure what column is causing this issue either since power bi isn't specifying... anyone had ideas to alleviate issue? 

[v-jiascu-msft · Accepted solution]

Hi @tahir9,

Did you try to change the data type in the Query Editor? Are they some underlines? 

Best Regards,

Dale

[tahir9]

Ah yes I did thank you!

[mehaboob557]

Hi @tahir9,

Go in edit queries. then clicl on source and update this in that [ReturnSingleDatabase=true, OldGuids=true, CommandTimeout=#duration(0, 1, 0, 0)])

may be some data will be not in a correct format. so this error may occur.

add with OldGuids=true in your source and your error will go.

Hope this may help you

Regards,

Mehbub

[tahir9]

Hello thanks for the reply but i am not sure what you mean... or where i can update that i am not seeing that when i go to edit queries and sources... ?