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.