Forum Discussion
Conversion failed when converting from a character string to uniqueidentifier
Hi Anonymous ,
it's case sensitive. Table.Buffer
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Same error, except now I get it in query editor and not when refreshing the table in Power BI:
DataSource.Error: Microsoft SQL: Conversion failed when converting from a character string to uniqueidentifier.
Details:
DataSourceKind=SQL
DataSourcePath=prod-sql.database.windows.net;prod-db
Message=Conversion failed when converting from a character string to uniqueidentifier.
Number=8169
Class=16
let
Source = Sql.Databases("prod-sql.database.windows.net"),
#"prod-db" = Source{[Name="prod-db"]}[Data],
dbo_vps_Sum = #"prod-db"{[Schema="dbo",Item="vps_Sum"]}[Data],
vps_Buffer = Table.Buffer(dbo_vps_Sum)
in
vps_Buffer
I tried deleting the relationship between this table and another but that didn't help either.
Hi Anonymous
is vps_Sum an SQL table or view?
What happens if you query
SELECT * FROM [dbo].[vps_Sum]in SQL Management Studio
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
This was the solution for me. We were trying to join nvachar to a uniqeidentifier, which is fine, but breaks if the field is empty
Hi Anonymous ,
did you solve your problem?
If I answered your question, please mark my post as solution, this will also help others.Please give Kudos for support.
Anonymous
This seems to be more related to Transact-SQL . You may visit https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=&forum=transactsql&filter=&sort=relevancedesc&brandIgnore=true&searchTerm=Conversion+failed+when+converting+from+a+character+string+to+uniqueidentifier.
