Forum Discussion
Super UserWe 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 Date value.". Not sure what is causing this problem? Is there something on powerbi service I need to change to get it going?
Help!
Thanks,
Parv
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
7 Replies
- CahabaData
Memorable Member
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
Yes it is type is date in powerbi desktop.
- CahabaData
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.
