Generate minute list in between an interval of datetime

[veasnamuch]

Dear Community,

I am very new in power bi, and I had a requirement of creating a report of an occupency of the resource in between an interval of time.

Below is an alloaction of the resource schedule.

We would like to monitor the resource occupency every 5 minutes. Can we use Power Query with Direct Query mode to generate table in below result?

I would like to generate power bi report in this format

I have tried to generate table using Power Query by adding custom column where formula is ={Number.From([Start Date Id])..Number.From([End Date Id])}

And generate list of value as below

But when I apply change, I got error message saying that

[v-juanli-msft]

Hi @veasnamuch 

I can reproduce your issue.

This is a limitation of DirectQuery mode, I am afraid that you need to switch to Import mode to make the function work.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[veasnamuch]

Dear Maggie,

Import mode will create a hude file of pbix right? The data will not get updated on the report untill we there is a schedule refresh dataset, which re-import again data to the report right?

Best regards,

Veasna