4
Currently in Resources (Bookableresource) you can only add Work hours by the web interface and or add a template.
The access to this data by resource is not very usable for charting or reporting in Power BI

Can we have the Work Hours entity updated so it can be viewed in a table type View and bulk updated like with Open in Excel Online
I want access to the Utilisation data to map into charts and Power BI
There is a current limitation where you can only apply a Work Hour template to 25 selected resources at a time. This is not manageable if you need to regularly adjust resource work hours for 1000 resources on a weekly basis
The CDS Connector does not allow connection to the Calendarrule table to map resource work hours
I've tried using FetchXML to pull the data but that also gives an error.
There needs to be a better way. This seems to be a real gap in Field Service capability.
The Analytics Report function only provides access to admins and doesn't allow the correlation of other dimensions with the work hours data eg. Weekly Booking hours versus working hours. Team leaders need this data reporting.

thanks,
Dave
STATUS DETAILS
Needs Votes