Forum Discussion
Data type DateTime doesn't work with Post Dataset API method
Hi,
I'm currently trying to post a push dataset using the API. It works fine with strings and integers but when I set a column data type to DateTime I'm not sure if it works. The post request sends without issue but when I create a report on the dataset the date field doesn't have the calender icon it usually has next to date fields and there is no date hierarchy.
I'm not sure whether there is something else I have to send to the API, something I'm doing wrong or whether it's just not possible but any help would be appreciated.
Thanks
6 Replies
You need to send the datetime columns to the push dataset API in ISO8601 format.
HI Anonymous,
Can you please share some more detailed information about your operations steps?
How to Get Your Question Answered Quickly
Notice: please not attach sensitive data in your sample.
Regards,
Xiaoxin Sheng
That is not ISO8601 format. I am formatting my datetime values in 8601 and have no problems pushing rows into the streaming dataset.
Sorry what I was saying was I am formatting my datetime values in ISO8601 (yyyy-MM-ddTHH:mm:ssZ) and pushing them into the dataset but then when I create a report on the dataset and look at the data as a table it formats it as dd/MM/yy HH:mm:ss. So therefore, power bi must recognise that the input data is a datetime or why else would it format it.
