Hour range on DirectQuery PBI

[jlhy]

Hi experts,

I have been trying to research around on how to perform a data transformation to my "time" field from fact table.

There have been many forums talking about it, eg performing DAX but in my specific scenario, I am using a DirectQuery approach to perform a transformation but it kept saying that this kind of change is not supported in DirectQuery.

Eg, I have timings like 11:43:00 am, 12:10:00 pm, 12:11:00pm.

I would like to have it class by 1100 - 1200, 1200 - 1300

If I can only use DirectQuery method instead of import, how can I achieve this?

Sorry if this has been asked before but I just can't find one yet. Appreciate if anyone could guide me to the right path.. thanks!

[amitchandak · Accepted solution]

@jlhy , Either you need to create a timetable or bucket in your source database and use that (Join to this table)

or create time table in import mode

example of power bi import mode. you can join it with time column of direct query table too

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/