Onedrive datasource and date field

Hi All,

I am new to PowerBI and I am keep my data file(excel) on Onedrive business. Columns in the excel are as screenshot

From service I am creating dataset and linking the excel file and then for the report I am using the published dataset. On the report I am getting some additional fields as below and these are not nested under the off_yr or off_time (there is no off_time field)

It seem likeoff_time excel column is showing as three fields in the report (off_Date, off_Month and off_Year). Could you please tell me why this is happening and how I can stop it? I just want to show off_time as data/time.

Above behaviour was not happening when I using the source file from local. It only started happening when i moved my data file to one drive.

Secondly, some of the columns in the excel are numbers but they are not showing as numbers in the report. What I am missing?

Thank you in advance

Cheers