none
DataFormat.Error: We expected value, but found 'g' at position 0. RRS feed

  • Question

  • I get this error

    DataFormat.Error: We expected value, but found 'g' at position 0.

    Tracing is turned on and it isn't present in the diagnostics trace. I've see a couple other mentions of it when Googling, but nowhere was an explanation given.  Us users need better/actionable error messages.

    Friday, October 9, 2015 9:35 PM

Answers

All replies

  • Do you receive this error as a value inside a cell in the Query Editor? If not, can you share more context - Where do you see this error?
    Saturday, October 10, 2015 4:01 PM
  • Hi Gil,

    No. It's in an alert box/panel. Happens when I submit the query. I can get a screenshot if that will help. Another error I got was:

    DataFormat.Error: We expected a value, but found "" at position 8

    In Visual Studio, for example, when there is an error, the editor highlights the expression containing the error. It would be really helpful if Power Query would do something similar.

     - Chris

    Saturday, October 10, 2015 4:28 PM
  • Hi Chris. Yes, a screenshot would be helpful. It's not clear where this message is originating.

    Ehren

    Tuesday, October 20, 2015 5:40 PM
    Owner