Forum Discussion

sunil's avatar
sunil
New Member
10 years ago

DataFormat.Error: We cannot convert the specified value to the specified type.

Hi   Am new to PowerBI ,    i got this struck with an error ,while loading one of the table(Accounts) from salesforce to PowerBI     = Source{[Name="Account"]}[Data] DataFormat.Error: We cann...
Need Help
Evogelpohl's avatar
Evogelpohl
Helper V
10 years ago

I was able to remove the offending column w/ this code.  I no longer get the error.  Perhaps this GoeLocation column is some type of derived or component field for SalesForce and PowerBI can't convert it.

 

let
    Source = Salesforce.Data(),
    MyTable__c = Source{[Name="MyTable__c"]}[Data],
    ColRemoveGeo = List.Select(Table.ColumnNames(MyTable__c), each Text.StartsWith(_, "GeoLocat")),
    FinalMCRTable = Table.RemoveColumns(MyTable__c, ColRemoveGeo)
in
    FinalMCRTable
konstantinos's avatar
konstantinos
Memorable Member
10 years ago

Evogelpohl  Amazing solution, thanks. Just for your info the same column produced the error to me also.

  • konstantinos's avatar
    konstantinos
    Memorable Member
    10 years ago

    Evogelpohl The same column , at least in my custom tables (4), produce the error in multiple tables. Seems like an error on this column on all custom objects that contains it.