Forum Discussion

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
6 years ago

DataFormat.Error: We couldn't parse the input provided as a Date value // From a Salesforce Reports

Hi guys, I get this error and I have no idea what do next. So, I've connected to a report I've created in Salesforce via Salesforce Reports. So far, so good, right? Unfortunately, I get this error...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi AliceW 

You can connect to the SalesForce reports from Power BI successfully, right?

But when going to next step(Navigation), there is an error coming out, right?

 

If so, it seems the "date" column in your data source don't match the format in Power BI.

You could transform the column with Power query.

Here are some similar threads you could refer to.

https://community.powerbi.com/t5/Desktop/Stuck-on-a-date-issue/td-p/428946

https://community.powerbi.com/t5/Desktop/DataFormat-Error-We-couldn-t-parse-the-input-provided-as-a/td-p/84355

 

Please give me more detail information so that i can make a test and provide a more clear solution.

eg, the two question at the begining of my reply,

what is the column which cause an error?

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

  • AliceW's avatar
    AliceW
    Icon for Power Participant rankPower Participant
    6 years ago

    Hi Maggie,

    I can connect to Salesforce and, yes, the next step, 'Navigation', is blocking everything.

    As the table is not displayed at all (the 'Navigation' is the first step), I can't modify the column.

    I've looked at the threads you sent, but I can't figure out how to match with what I have...

    Thank you!

     

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi AliceW 

      I have tried to reproduce this error, but still can't.

      Could you firstly check if you use the lastest version of Power BI Desktop(2.76.5678.782)?

      As soon as i find the solution, i will update to you.

       

      Best Regards
      Maggie
      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.