[Problem with PowerBI report refresh]

Hi

This problem is still ongoing. I was advised to schedule all the reports before running them in PowerBi but this has not resolve the refresh issue.

 

Can someone advise if there are problems with report refresh?

Thanks.

 

Regards Joyce

[Problem with PowerBI report refresh]

Hi @Steve G

When I refresh the report from PowerBI, i don't get any error, and looks like it has refreshed. But when I check on Hornbill report history , no report has run at the particular time.

 

Regards,

Joyce

[Problem with PowerBI report refresh]

@Bob Dickinson or anyone..any ideas?

[Problem with PowerBI report refresh]

Hi @Bob Dickinson

None of our PowerBI report are refreshing. When I tried to refresh from PowerBI, I am not getting any error and looks like the refresh has completed. But the data is not updated on the report, and on Hornbill Report History, there is no new report. 

Has something change which requires the  RScript we are currently using to connect PowerBI to Hornbill report to be updated? I have notice the reports not running for the past 3 weeks.

 

Thanks.

Regards,

Joyce

 

[|Measures]

HI,

 

I have use the below query to create a measure. Basically i want to create different measure for counting specific tickets logged monthly, but with deferent series  for different years. So for example:

Series 1- for 2018

Series 2 for 2020

Series 3 for 2021

Series 4 for 2022

 

Query used for 2020:

h_datelogged >='2020-01-01 00:00:00' and h_datelogged <='2021-01-01 00:00:00' And     h_fk_team_name like '%Procurement%'.

 

with the monthly run cycle and max sample history 68 as follows:

Frequency

                                 Daily                                 Weekly                                 Monthly                                 Quarterly (January/April/July/October)                                 Quarterly (February/May/August/November)                                 Quarterly (March/June/September/December)                                 Yearly                             

Value Aggregate

                                 Count                                 Sum                                 Average                                 Floor                                 Ceiling                                 Percentage                             

Maximum Sample History

Scorecard limit

Sparkline Limit

 

This however, seems to run from beginning of the sample( back in 2017), how can I set it to only run for Jan 2020 to December 2020? and only display samples for this period?

I think this query will take a long time, looking at whole data, to display zeros for values outside of the above period.

Thanks.

Regards,

Joyce

 

 

[Data retain for creating Measures/ widget on the application]

Hi,

How far back are the data retained on the application level?

I am trying to create a measure for count of ticket in 2017, 2018, 2019, 2020, 2021, to compare the increase of ticket logged from 2017 to 2021. I can only get data as far back as August 2020.

This is for 2019, but I get values from 01/08/2020.

 

Thanks .

Regards,

Joyce

[Changes in R-Script for PowerBI connection]

Thanks James

[Changes in R-Script for PowerBI connection]

Hi @James Ainsworth

One of my colleague has mention that there are some changes made in R-Script which is used to connect data to PowerBI. Apparently the current script has ' issue with spaces in filenames' .

How will this problem affect the reports?

Changing of R-Script for us will require a lot of effort and time, as we create multiple Dataset for each dashboard / Report, and we have more than 50 reports in operation at the moment. This means I might be changing 200+ script to accommodate the change. I should rather not do this, if this change is more 'cosmetic- Good to have' rather than 'Required'.

 

Thanks.

Regards

 

Joyce

[Reporting- Row limitation]

HI @Steven Boardman,

Thanks for the above.  As our reporting are in PowerBI using measures does help, but have limitation on how many column/ field can be brought to PowerBI and how we can filter reports within PowerBI.

 

,

 

[Reporting- Row limitation]

Hi,

As there is limitation on amount of rows which can be moved to PowerBI reporting, is there a way to group by date ( either logged or resolved) and do a count  on the month within the date?

We would like trend ticket logged/ Resolved  monthly for the past 12 month, but currently as the volume of tickets increase we can only review 3 month at a time.

 

Thanks.

Kind Regards,

 

 

[Request Resolution Duration]

Thanks @Victor

[Request Resolution Duration]

Hi,

What is the difference between Request Seconds(h-itsm-requests.h-fixsecs) and Request Resolve Time (h_itsm_requests.h_fixtime) ?  Which one is the accurate time in second it took a ticket to be resolved.

Regards,

Joyce

[Power BI: Unable to connect: We encountered error while trying to connect]

Hi,

We have been getting the below error when trying to connect to PowerBi with some of the reports which were not connected before :

Unable to connect:

We encountered error while trying to connect

Details: "ADO.NET: R script error.
Error: Execution halted"

This has only been experienced today.

Any help?

Thanks.

Regards,

JOyce

 

[Power BI - ADO.NET: R script error. Error: The report 'xx' is already running.]

Yes, getting this more often after changing of the R Script. It usually complete running after a while ( even if the report itself is very small with less than 50 rows).

 

I have also notice, that since changing of R Script, the reports are taking too long to run and load in PowerBI

 

[Adding dates directly on Change Calendar]

Hi,

Has there been development on Change Calendar to enable adding dates directly on the calendar instead of through a request?

We would like to pre-add our planned maintenance dates at least 6 month in advance so everyone on the team is aware of the dates.

Thanks.

Kind Regards,

Joyce

 

[Error when trying to add members on workspace by Group]

Hi @Daniel Dekel,

 

Yes the group did have basic users, which I have now remove them :-)

 

Thanks.

 

Regards,

Joyce

[Error when trying to add members on workspace by Group]

Hi,

I am getting errors when I try to add members on workspace by 'Group'. 

Error Details:

/apps/com.hornbill.core/flowcode/fc_modules/xmlmc.js(189): error X1001: Uncaught EspMethodCall::invoke: Operation[activity::workspaceAddMember] The specified user does not exist

 

Thanks.

Joyce

 

[Reporting issues - csv output corrupted]

Thanks @Steve G, but still getting 'DataFormat.Error: Unable to translate bytes [E2] at index 24 from specified code page to Unicode.'

I have install 'readxl' package as per the above and select both CSV and XLSX output format on the report.

I also tried with on XLSX output format, which didn't return any data

 

Regards,

Joyce

[Reporting issues - csv output corrupted]

Hi @Steve Giller

We are experiencing the same issues as @m.vandun. Can't connect the report to PowerBI.

We have  lots of reports for different division, which we will need to update R Script as per the change. So a quick resolution for this will be very appreciated.

 

Thanks

[Share 'Chart' for Shared Views]

Hi Daniel,

Yes it is working on  my side.

Thank you.

Joyce

[Share 'Chart' for Shared Views]

yes, but this can not be viewed by the user who I have share 'My View' with

[Share 'Chart' for Shared Views]

Hi ,

Is it possible to share Graph/ charts created from Views?

Thanks.

 

Regards

Joyce

 

[Adding a link to a 'View' on Workspace 'Billboard notice']

Hi James,

I required the View for interaction purpose. So I can click on the tickets and see updates. If I do on report/ Dashboard I will have to copy the ticket number then search for it.

I already have PowerBI dashboard from a report which give details of some fields, but off course won't be able to see the timeline updates.

Regards,

Joyce

[Adding a link to a 'View' on Workspace 'Billboard notice']

Hi,

How can I add a link, which will take me to a 'view' with list of ticket (created a view of tickets with certain condition) on workspace?

We want to use Workspace to collaborate Our daily triage on workspace and wants to have a view of ticket related to triage issues discussed.

 

Thanks.

Regards,

Joyce

[Approval Node (Task)- email notification]

Hi,

Is there a way to set an email notification to task assignee , when an Approval task is created and assigned to them?

We use authorisation node for our change request, this is usually assigned to up to 3 users ( with weight distribution among them). How can I set an email to be sent to them when these task are created?

Thanks.

Regards,

Joyce