Salesforce report Dataformat.Error Power Query

Hi Anonymous - yes I have, but only in the context when using Table.TransformColumnTypes to change a datetime string to date.  Power Query can sometimes get confused, so you need to convert the String to DateTime then to Date.  The following shows how the error occurs when changing the DateTimeZone string straight to Date.  Instead you need to Convert to DateTimeZone first, then convert to date.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtI1NNA1NAwxtLAyMACiKKXYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    // This contains your Error message
    #"Change Data Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}),
    #"Add DateTimeZone From" = Table.AddColumn(Source, "DateTimeZoneFrom", each DateTimeZone.FromText([Column1])),
    #"Parsed Date" = Table.TransformColumns(#"Add DateTimeZone From",{{"Column1", each Date.From(DateTimeZone.From(_)), type date}})
in
    #"Parsed Date"

Unfortunately, In this situtation, it looks like the Saleforce Connector contains a step to take the current DateTimeZone when you run the report.  It is getting confused by the format of the DateTimeZone so it cannot parse the date. 

You may need to create a support ticket with Microsoft to identify root cause because it is inside the Salesforce Connector.  

I would try the following options in the meantime:

1. Use Power BI Dataflow to see if the issue occurs online
2. change the locale setting for Power BI file

Are you using the Salesforce.Data or Salesforce.Reports?