How can we filter time in hour , minute and second for a date time datatype field from PowerBI Web?

[savanth]

Hi all , Am stuck up in an issue in power Bi web , that am not able to filter a date time field in hour , minute and second which is a dataset i created using Power BI Rest API . The same when I tried from Power BI Desktop , am able to change the datatype option against a field . So when I tried with that , I changed the datatype of a field to date time , and publish , it shows the exact data what am expecting . But when trying from a service and pushing my data against a field set datatype as date time using Power BI Rest API , it only shows the date in the table chart . When we look on the filter option of that particular field , I can see the time also along with the date . So it meant time is also added in that field . But when drag and drop that date time field into a chart , it shows only the date . 😞 Please do a response as early as possible .

[Sreejith]

Hello Charles, Sorry for the delayed response. Below is the rest api and sample json data we are pushing to PBI via rest api https://api.powerbi.com/v1.0/myorg/datasets/0c47e3b2-86f5-4365-af8d-0816d9a73896/tables/RecoStatsDevTest/rows {"rows":[{"Timestamp":"\/Date(1466066920831)\/","TotalChars":10701,"TotalImages":5,"MaxCpuRecognition":493}]}

[chass]

Closing until i hear back

[chass]

Can you include the REST call you are making that is not returning the correct results? Thanks Chuck