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
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

i think it's a query folding problem.

Do you merge the query with another query?

 

Maybe you can use Table.Buffer.

https://docs.microsoft.com/en-us/powerquery-m/table-buffer

Think of Table.Buffer as, "load this table into memory, and stop folding subsequent operations back to the data source".

 

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
6 years ago

The other options didn't work so I'm trying to use table.buffer but Im getting the syntax wrong. Do you know what I'm doing wrong here?

 

error: Expression.Error: The import table.buffer matches no exports. Did you miss a module reference

 

 

let
    Source = Sql.Database("prod.windows.net", "prod-db"),
    dbo_vps_Sum = Source{[Schema="dbo",Item="vps_Sum"]}[Data],
    dbo_vpsView_SumBuffered = table.buffer(dbo_vps_Sum),
    #"Replaced Value" = Table.ReplaceValue(dbo_vpsView_SumBuffered,"D MHS","D",Replacer.ReplaceText,{"End Customer"}),
    #"Trimmed Text" = Table.TransformColumns(#"Replaced Value",{{"End Customer", Text.Trim, type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Trimmed Text",{{"End Customer", "End Customer(OneView)"}})
in
    #"Renamed Columns"