Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conversion failed when converting from a character string to uniqueidentifier

I'm getting the following error on a table from SQL Server: OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Conversion failed when converting from a character string to uniqueidentifier.. D...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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