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..

Does anyone know how to get around this? I dont believe there is much I can do to change the table, since I need one of the columns to be the primary key.

Need Help

9 Replies

  • 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"

       

       

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

     

    I would one of two things in Power Query Editor

    A. Change the data type to String but make sure it over-write the original

    or

    A. If you do not need the column, write a SQL Select and do not select the column in question

     

    I hope this might help

    If I answer your question, please mark my post as a solution, this will also help others.
    Please give Kudos for support.

    Tomas Santandreu Polanco |Principal Business Intelligence Consultant
    www.designmind.com