Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @tahir9,
Did you try to change the data type in the Query Editor? Are they some underlines?
Best Regards,
Dale
Hi @tahir9,
Did you try to change the data type in the Query Editor? Are they some underlines?
Best Regards,
Dale
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
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... ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |