The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
In my excel file I have columns formatted only with time hh:mm:ss.
When I upload the file to power Bi it adds a random date.
Is there any way to make power BI just pick the time or take the values of the excel file as it is.
Thanks
Solved! Go to Solution.
Yes! You just need to go to Power Query (Transform Data) or the Table view in Power BI and change that column type to "Time" only. It is defaulting to Date/Time which is unnecessarily adding that date. The screenshot I have attached is from the Table view.
Hi! In Power Query, you can choose the Time format instead of Date/Time or you can split the date and time, format the time as time and delete the date column since you don't need it.
Proud to be a Super User! | |
Yes! You just need to go to Power Query (Transform Data) or the Table view in Power BI and change that column type to "Time" only. It is defaulting to Date/Time which is unnecessarily adding that date. The screenshot I have attached is from the Table view.
One question that it just came to my mind. If I update the table with a new excel file, will I need to set up the format again in the table?
Thnak you! I'm still new to power BI and didn't it was this easy.