cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
divyanshmalik Frequent Visitor
Frequent Visitor

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
Super User
Super User

Re: Time component is missing in datetime type data in powerBI table

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


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

Proud to be a Datanaut!


mike_honey
Advisor

Re: Time component is missing in datetime type data in powerBI table

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...

 

Highlighted
Sreejith Frequent Visitor
Frequent Visitor

Re: Time component is missing in datetime type data in powerBI table

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-...