Skip to main content
Microsoft Idea

Power BI

Needs Votes

Improve Direct Query Date Time Handling

Vote (700) Share
Sam Bloggs's profile image

Sam Bloggs on 14 Jun 2016 21:06:14

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!

Comments (76)
Sam Bloggs's profile image Profile Picture

Federico AIROLDI on 23 Feb 2024 14:07:16

RE: Improve Direct Query Date Time Handling

Much needed, should be BASIC for a BI Report system, IMO; to be able to handle datetimes in a comfort way instead of tweaking things arounf.

Sam Bloggs's profile image Profile Picture

Gus Valen on 08 Nov 2023 17:15:07

RE: Improve Direct Query Date Time Handling

Agree I'm trying to do simple Dynamics 365 sales analysis in powerbi with direct query. @microsoft maybe add in a calendar into Dynamics 365 CRM/Sales if not?

Sam Bloggs's profile image Profile Picture

Janis Berzins on 31 Oct 2023 13:27:49

RE: Improve Direct Query Date Time Handling

A must have option. Currently doing this manually year, month, etc shows months not by their name but number. I believe the every user who used Direct Query would benefit from this greatly.

Sam Bloggs's profile image Profile Picture

Chrysa Lel on 03 Oct 2023 09:59:58

RE: Improve Direct Query Date Time Handling

This is frustrating. Dates are a key element for all our dashboards!

Sam Bloggs's profile image Profile Picture

Will Drotar on 18 Jul 2023 16:02:41

RE: Improve Direct Query Date Time Handling

Submitted in 2016, 650+ votes. Come on, Microsoft!

Sam Bloggs's profile image Profile Picture

Kit MacInnes-Manby on 13 Jul 2023 10:29:46

RE: Improve Direct Query Date Time Handling

Why is this not standard, seems ludicrous

Sam Bloggs's profile image Profile Picture

Tristan Ozinga Ozinga on 23 May 2023 01:45:31

RE: Improve Direct Query Date Time Handling

It's May 2023 and still this most useful feature with Import mode is not standard in Direct Query.

Sam Bloggs's profile image Profile Picture

Connor Doherty on 24 Apr 2023 16:26:46

RE: Improve Direct Query Date Time Handling

Should really be standard

Sam Bloggs's profile image Profile Picture

Kevin Nelson on 01 Mar 2023 22:36:01

RE: Improve Direct Query Date Time Handling

This would be a very useful feature.

Sam Bloggs's profile image Profile Picture

Mike Hapner on 04 Jan 2023 18:40:59

RE: Improve Direct Query Date Time Handling

How is it even possible that this isn't automatic?!?!?!?