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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors