Showing results for 
Search instead for 
Did you mean: 
New Member

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

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 . 



Savanth S 



Issue PowerBI.png

Super User IV
Super User IV

You should post this in Issues. I have seen a number of other problems posted here with datetime fields when using the Rest API.


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors