Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
veasnamuch
Frequent Visitor

Generate minute list in between an interval of datetime

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.

 

09Sep2019-001.PNG

 

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?

 

09Sep2019-002.PNG

 

I would like to generate power bi report in this format

09Sep2019-003.PNG

 

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

09Sep2019-004.PNG

 

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

09Sep2019-005.PNG

 

 

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

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.

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 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.