cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
divyanshmalik
New Member

Time component is missing in datetime type data in powerBI table

We have two datasets both contains a column with datetime value. When we create a table using first dataset then it shows date in powerBI in dd/mm/yyyy hh:mm:ss am format however with second dataset it only shows date in dd/mm/yyyy format and the time component is lost. powerBI setting for both datasets are same also when we export the data from powerBI for second dataset then the exported data in excel shows the date with time.  First dataset was created in Febrauary 2016 and second dataset was created in April 2016.

Please let us know the reason which can cause the powerBI to not show the time component in a datetime type data.

1. Table from first dataset:

  

2016-05-18_194709.png

2. Table created with second dataset:

2016-05-18_195019.png

 

 

 

 

 

3 REPLIES 3
mike_honey
Power Participant
Power Participant

I would rebuild this dataset and its reports in Power BI Desktop, where the Edit Queries window gives you control over datatypes and a lot more.

 

Also take a moment to upvote this suggestion (or any similar ones you find) which would make this task a snap if they had built it already ...

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10936488-export-powerbi-com-to-po...

 

Greg_Deckler
Super User IV
Super User IV

Where are the two datasets coming from, the same source or different sources?


---------------------------------------

@ 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!




Hi @Greg_Deckler I am also facing the same issue. I am able to create a dataset with time component with PBI desktop. But when i push data to a dataset created via Rest api , the Datetime value is added as a String type. Isn't it possible to have datetime field in table created via rest api?

this link says it is possible http://www.microsofttrends.com/2015/02/17/pushing-data-into-power-bi-preview-using-the-new-rest-api-...

Helpful resources

Announcements
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!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors