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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
thukten
New Member

Data type time format issue

Hi Experts,

 

I have my data type format in time in SAP BW and when i load same data to power BI, it is automatically convert to text format. The below screenshot show data in time format.

thukten_0-1671015966668.png

The below screenshot shows same data in text format.

thukten_1-1671016048131.png

Any could help me for converting text to time format in power BI. Why its converting automatically in power BI?

 

 

1 ACCEPTED SOLUTION
Mahesh0016
Super User
Super User

select column >> Top Column tools >> Data type drop down select time data type.

Mahesh0016_1-1671017922880.png

 

 

View solution in original post

2 REPLIES 2
thukten
New Member

Those solution does not resolved the issue

Mahesh0016
Super User
Super User

select column >> Top Column tools >> Data type drop down select time data type.

Mahesh0016_1-1671017922880.png

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.