Forum Discussion
Dataset was changed but cannot refresh
The data typing you set in Excel will only have a minor impact on your Power BI. This will generally effect the "display" data in excel, rather than how its actually stored in the file itself.
Its the data typing steps you set in your Power Query that you need to concentrate on. You need to look in "Transform Data" inside Power BI and make sure you have your field set to the correct data type.
I would recommend have the column set to "Time" and not TEXT. Once you have it set to the correct "Time" data type, you can use the column tools to set how you want it displayed.
Anonymous ,
even though I changed my excel now to Text Type, its not impact to the existing data?
The data typing you set in Excel will only have a minor impact on your Power BI. This will generally effect the "display" data in excel, rather than how its actually stored in the file itself.
Its the data typing steps you set in your Power Query that you need to concentrate on. You need to look in "Transform Data" inside Power BI and make sure you have your field set to the correct data type.
I would recommend have the column set to "Time" and not TEXT. Once you have it set to the correct "Time" data type, you can use the column tools to set how you want it displayed.