Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Memorable Member
Memorable Member

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

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors