Forum Discussion
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...
I had a similar issue and tried to implement this fix to see what was going on. Ended up getting a firewall error. In the end I just removed as many columns as possible (ie just left with an Id and CreatedById) and my query worked.
Make sure you remove columns as soon as possible to force the query folding. Essentially you just don't want PBI to pull the table from Salesforce at all (seems most people are having this issue when accessing Salesforce).