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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DeonDP2
Frequent Visitor

Imported date column in Power Query does not display the column as date type in desktop Fields pane

Hi Team

 

I am reaching out to the clever people on the forum to help me with this one.

 

I have imported 2 date columns in Power Query (picture below is a screenshot in desktop table view)  All the formats seem to be good as date columns:

 

DeonDP2_0-1666914509727.png

 

However, my problem is that in the Fields pane it does not show it as a date column, so having some issues with the visualisations because of it:

 

DeonDP2_0-1666914886852.png

 

 

I created another column in Power Query after the import (Date Today) and that works fine.  Just can't figure out how to get the format in the fields pane correct.

 

As always - thank you for your time and effort to answer my question.

 

D

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@DeonDP2 , In case you have joined Hire Date with a Date table it will lose auto time Hierarchy.

A date table marked as a date table will not have date hierarchy for the key date column and all dates joining that key will not have a hierarchy too

 

If the data type is date that should be fine. You can use column from date table 

 

These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@DeonDP2 , In case you have joined Hire Date with a Date table it will lose auto time Hierarchy.

A date table marked as a date table will not have date hierarchy for the key date column and all dates joining that key will not have a hierarchy too

 

If the data type is date that should be fine. You can use column from date table 

 

These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045

Thanks Amitchandak

 

I inherited  a model that I am working on where the date columns had inactive releationships with the Date table that some of the measures created by my predecessor depended on.

 

When I removed the relationships, the measures were affected, so I had to make another plan.

 

Simple solution was to make a copy of the 2 columns in Power Query and voila!!

 

Thanks for your direction on this issue.

 

DeonDP2_0-1666925390437.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.