Forum Discussion
Solved
Extra fields in Power Pivot Received_Time(Hour) and Received_Time(Minute)
I have a field Received_Time in my Data Model. This field is defined as a data type Time. When I look in Power Pivot, I see the two extra fields below and when I drag in Received_Time into Power Pi...
This is a "helper" feature in Power Pivot. It isn't really extra fields. It is creating an heirarchy. You will see the same with date - you'll see Year, Month, Day.
See if you can disable it in Excel's options, Data section. This is not a beloved feature, and Power BI Desktop doesn't do this.
This is a "helper" feature in Power Pivot. It isn't really extra fields. It is creating an heirarchy. You will see the same with date - you'll see Year, Month, Day.
See if you can disable it in Excel's options, Data section. This is not a beloved feature, and Power BI Desktop doesn't do this.