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.
The existing data is of type "Text", which you can see in your screenshot as it says "Text Filters". Your new shot shows "Date Filters" which means it has successfully data typed it as one of Date/Time/DateTime.
This says to me that your Power Query code and the mix of data types in the "existing data" do not work. You would need to add additional steps in your Power Query code to transform the "existing data" further to allow it to data type correctly.