Onedrive datasource and date field

[Anonymous]

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

[v-kelly-msft]

Hi @Anonymous ,

Check whether below feature in desktop is enabled:

Best Regards,
Kelly

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

[amitchandak]

@Anonymous , Are getting these from excel from One drive or from the power Bi dataset?

[Anonymous]

@amitchandak, report is linked to powerbi dataset now. and powerbi dataset was populated from the excel on onedrive for business. thanks