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 se...
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.
HI Anonymous,
I think it may be related to power bi not add any verify of these posted data so that it only recognizes the default format of datetime values.
Perhaps you can submit an idea to add more DateTime format supports.
Regards,
Xiaoxin Shneg