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
Bjoern's avatar
Bjoern
Continued Contributor
10 years ago

What data types does the to-be-imported column have?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

I've no clue. The message is

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

and does not specify the offending column. if I write something like

let
    Source = Salesforce.Data(),
    Account1= Table.RemoveRowsWithErrors(Source{[Name="Account"]}[Data])
in
    Account1

it only gets 2001 rows with 1 error (and I don't understand which error)

 

  • Evogelpohl's avatar
    Evogelpohl
    Helper V
    10 years ago

    Having the same problem.  Created a custom object in SalesForce (tableX_c) and there must be a column(s) with a data_type that PowerQuery/PowerBi doesn't like.

     

    Suggestions?