Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sra2786
New Member

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 Pivot these two extra fields are always included and I have to delete.  How come there are these two extra fields and how can I get rid of them

EST_Time(Hour) 

EST_Time(Minute)

Thanks.

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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.

edhans_0-1645037622201.png

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

1 REPLY 1
edhans
Super User
Super User

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.

edhans_0-1645037622201.png

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.