Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
10 years ago
Solved

We couldn't parse the input provided as a Date value.

Hello,   I used PowerBI Desktop to connect to google sheet and it worked great. Now when I published the report to PowerBI Service it is complaining about "We couldn't parse the input provided as a...
Need Help
  • parry2k's avatar
    parry2k
    10 years ago

    Fixed, it was locale issue. If someone need to know more about this or need help, please send me an email at [email protected].

     

    thanks,

    P

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
10 years ago

go back to Desktop - and verify that the table/field in question is actually modeling as a date field.  typically PowerBI makes the right call - but not always.  If indeed that field is defaulting to text - then re-option it to a date type and republish up to Service.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    10 years ago

    Yes it is type is date in powerbi desktop. 

    • CahabaData's avatar
      CahabaData
      Icon for Memorable Member rankMemorable Member
      10 years ago

      Do a sort on that column A-Z and Z-A to see if you have any extreme outlier value like year 5000 or something.

       

      Right now that is all I can think of for the cannot parse type message. 

       

      You could do a sanity check and make a duplicate of the column with a different name and see if that will upload into Service okay.

       

       

       

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        10 years ago

        Fixed, it was locale issue. If someone need to know more about this or need help, please send me an email at [email protected].

         

        thanks,

        P