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"

 

 

  • 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

      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.