Microsoft Idea

645

Improve Direct Query Date Time Handling

Sam Bloggs on 6/14/2016 9:06:14 PM

645

When using direct query you should be able to change a date axis to show only the month. This works using excel or when doing a transform but neither of these are possible using DirectQuery. Even workarounds like FORMAT can't be used with direct query. This really needs fixing!

STATUS DETAILS

Needs Votes

Comments

RE: Improve Direct Query Date Time Handling

Tyler on 7/6/2020 12:02:06 AM

This needs to be implemented. The workarounds are extremely frustrating.

RE: Improve Direct Query Date Time Handling

Jorge Abreu on 7/6/2020 12:00:55 AM

Please allow this feature, it would avoid creating custom columns at all time.

RE: Improve Direct Query Date Time Handling

Nathan Collins on 7/5/2020 11:49:32 PM

This is definitely needed, but a workout we use is to bring in a date dimension table for each date we need a hierarchy on. It works when you're only utilizing a few dates.

RE: Improve Direct Query Date Time Handling

Brenda Johnston on 7/5/2020 11:48:46 PM

Help, I really need the date hierarchy with direct query.

RE: Improve Direct Query Date Time Handling

Laurent on 7/5/2020 11:47:25 PM

Yes. This is limiting drill-down capability with Direct Query.

RE: Improve Direct Query Date Time Handling

Praveenraj.k on 7/5/2020 11:47:21 PM

Hi PowerBI Team, I'm handling the bulk of time series data, if date hierarchy is available in the direct query, it will be more helpful to us

RE: Improve Direct Query Date Time Handling

Jeyakumar Seenivasagam on 7/5/2020 11:47:17 PM

Power BI team, Please consider this feature in the upcoming release.

RE: Improve Direct Query Date Time Handling

Jennifer Iler on 7/5/2020 11:46:38 PM

Need this now!!

RE: Improve Direct Query Date Time Handling

Denis on 7/5/2020 11:45:18 PM

Please add date hierarchy in direct query mode. Thankyou.

RE: Improve Direct Query Date Time Handling

Power BI User on 7/5/2020 11:43:11 PM

please add date hierarchy in direct query mode