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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
HuJa26
Regular Visitor

Visualizing report run times across the day

I'm probably just not using the right search terms here, but hoping someone can point me to some resources.

 

We have a log of reports being run throughout the day, providing us with the following data points:

- report name

- date start

- time start

- date end

- time end

- elapsed seconds

 

And I've gotten all of that parsed out into a table well enough with relationship to a date table and whatnot.  

 

What I'm hoping to achieve something like below, where we can visualize each report's elapsed time across a period of time (24 hours usually).

HuJa26_0-1774550425102.png

PBI is trying to aggregate the data, because that's usually the point. But since I'm trying to do each report as a separate item on the graph, I guess akin to a Gantt chart, but I'm not getting very far. Closest thing I've found are gantt charts across days of the month, not across minutes/seconds in the day. Anyone have any ideas about where I could learn about something like this?

 

Hope I explained that well enough, thanks in advance to everyone that looks at this! 

1 ACCEPTED SOLUTION

Here you go

lbendlin_0-1774834856245.png

 

Start and End need to be complete DateTime fields.

 

The Vega Lite code is very basic - you can change it as needed.

 

 

 

View solution in original post

4 REPLIES 4
HuJa26
Regular Visitor

Thank you for pointing me at Deneb! Exactly what I was looking for, and now I have a new tool to play with as well!

HuJa26
Regular Visitor

Thanks for replying @lbendlin 

The data looks like this:

ReportNameRunSecondsDateStartTimeStart
Report 16722/6/202612:06:33 AM
Report 26842/6/202612:17:45 AM
Report 36992/6/202612:29:09 AM
Report 47152/6/2026 01:00:58 AM
Report 56822/6/2026 02:04:40 AM
Report 6126302/6/2026 02:50:27 AM
Report 79342/6/2026 06:20:59 AM

 

And mapping it out with my advanced MS Paint skills:

HuJa26_0-1774827665443.png

 

Alternative to RunSeconds field, there are also DateEnd and TimeEnd fields.

 

Here you go

lbendlin_0-1774834856245.png

 

Start and End need to be complete DateTime fields.

 

The Vega Lite code is very basic - you can change it as needed.

 

 

 

lbendlin
Super User
Super User

This is easily achieved with a Deneb Bar chart with secondary x axis (for the end date). 

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

Top Solution Authors