Forum Discussion

sunil's avatar
sunil
New Member
10 years ago

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

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

I received the following error:  Data source error:  We cannot convert the value "[Table]" to type Table.  I was not able to find anything helpful online.  I wanted to let users know what caused my error.  I merged a table that was previously merged in the same query so when I expanded the newcolumn on the second merge the process failed.  The important fact of this error is that it did not occur in the development phase on the desktop.  The error occurred in the cloud when I tried to publish the report.

  • TristanKuesters's avatar
    TristanKuesters
    Resolver I
    9 years ago

    Hello,

     

    I have the same issue.

     

    On the desktop is work very well, but after the upload to the service the refresh doesn't work.

    My big issue is, that the I have a huge report with a lot of KPI and I didn't see where the issue pops up.

     

    Any idea?

     

    Best regards,

    Tristan Küsters