Power BI

Needs Votes

Improve Direct Query Date Time Handling

Vote (420)

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 (55)

Comments (55)

be577853 a0e1-ea11-a813-000d3a9b112e on 18 Aug 2020 22:17:59

RE: Improve Direct Query Date Time Handling

must need option

922601ba 0b96-4ff6-9a46-0e45a0f8dee2 on 10 Jul 2020 17:21:45

RE: Improve Direct Query Date Time Handling

Please look into this ASAP.

af5db490 67df-42af-9417-bddaddd78244 on 06 Jul 2020 00:14:54

RE: Improve Direct Query Date Time Handling

Please add this! Agree wholeheartedly that Direct Query & Import modes should have the same date handling functionality!!!

4fca0bac 146e-4908-9294-4e5258e9ef20 on 06 Jul 2020 00:13:35

RE: Improve Direct Query Date Time Handling

Please add DATE HIERARCHY in Direct Query mode also. Why there is such a difference in import and direct query mode. Too much difficulty in handling such situation.

4f823dc8 8288-4f54-afb9-aca1fd12edbf on 06 Jul 2020 00:13:02

RE: Improve Direct Query Date Time Handling

I do not understand why direct query acts differently than import. This needs to be fixed. I am spending silly amounts of time trying to work around it.

b4573de0 82c0-48f0-84e2-859e35593b59 on 06 Jul 2020 00:12:37

RE: Improve Direct Query Date Time Handling

Import and DirectQuery data connectivity modes should have the same common functionality of Date/Calendar hierarchy. This is so overdue from Power Bi team. Please consider implementing it as soon as possibly can.

I would rank this request from user community above all new futures released monthly.