Jump to content

MizeelA

Hornbill Users
  • Posts

    12
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

MizeelA's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

2

Reputation

  1. Hi All, I am having the below issue when refreshing my hornbill Power bi report . I have regenerated the keys via systems - organisation data - users - system administrator but after refreshing it, this didn't fix the issue. The error message from Power query DataSource.Error: ADO.NET: R script error. Loading required package: bitops * Trying 78.129.173.117... * Connected to eurapi.hornbill.com (78.129.173.117) port 443 (#0) * successfully set certificate verify locations: * CAfile: C:/Users/michael.amofa/Documents/R/win-library/3.5/RCurl/etc/ca-bundle.crt CApath: none * error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version * Closing connection 0 Error in function (type, msg, asError = TRUE) : error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version Calls: invokeXmlmc -> getURL -> curlPerform -> <Anonymous> -> fun Execution halted Details: DataSourceKind=R DataSourcePath=R Message=R script error. Loading required package: bitops * Trying 78.129.173.117... * Connected to eurapi.hornbill.com (78.129.173.117) port 443 (#0) * successfully set certificate verify locations: * CAfile: C:/Users/michael.amofa/Documents/R/win-library/3.5/RCurl/etc/ca-bundle.crt CApath: none * error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version * Closing connection 0 Error in function (type, msg, asError = TRUE) : error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version Calls: invokeXmlmc -> getURL -> curlPerform -> <Anonymous> -> fun Execution halted ErrorCode=(2147467259) ExceptionType=Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException I checked the certificate but it seems this was revoked in 2018 but the report stopped working thsi friday. * CAfile: C:/Users/michael.amofa/Documents/R/win-library/3.5/RCurl/etc/ca-bundle.crt Could any please advise? Regards MizeelA
  2. @Gerry, Wow! This is exceptional. Thank you for taking this on-board and proactively delivering a solution. Lastly, on behalf of my company we will like to thank you and all the team for the insightful event. It was really brilliant!
  3. Hi @Steve G, Thanks for your response. You are right, Power BI authentication wasn't recognising the installed gateway (personal mode). After reviewing the pages from you and from Microsoft website , it seems to be a known issue with the personal gateway. The workaround available is as per below; 1. Open the On-premises Data Gateway (personal mode) desktop app on the machine where the gateway is installed. 2. Go to the connectors tab and switch off the Custom data connectors feature. 3. Click Apply -> Apply & Restart. 4. On the data-set page, click edit credentials and sign in. This resolved my issue and now able to schedule refreshes etc. Thanks for all your help @Steve G and @Victor . Kind Regards Michael
  4. Hi Steve, any assistance will be much appreciated.
  5. Hi , having issues scheduling a report in Power bi service after publishing from the desktop. Under the data source credentials it comes up with the below information. Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again. When I select the Edit credentials I am on unable to sign into the data-source of the report or change the authentication method from windows. My login and password is the same as for windows and in Hornbill. Am I missing something? Guidance will be much appreciated. Regards MizeelA
  6. Hi Trevor, It looks like this #Define Instance Details instanceName = "Ammic" instanceZone = "eur"
  7. Hi I have now been installed all the packages via the CRAN repository, which connects correctly but It doesn't show any table under R folder. Am I missing something? I have attached a screenshot of the navigator from power bi. Regards Mizeel
  8. Thanks Victor your help. I was able to amend the view details form in service manager under service portfolio menu -> catalogues -> request config.
  9. Thanks Victor for your quick reply but I don't want to fields to be presented to the user logging the ticket I want to the service desk team to see after the ticket is logged. Such as the external ref no, source which is the default but the user doesn't see it. Does this still need adding to via custom field mapping?
  10. Hi We are trying to add additional fields (add spare fields) to the design template in order to increase our options when a ticket is logged. I have added an additional spare field to an already created ticket which is fine but it does effect any new tickets logged. Is there a way to change the template to create more fields under the design? Could you please advise on how we could achieve this? Screenshot attached
  11. Hi All, I am new to hornbill but my company is trying to report from Power bi using hornbill data. Following the link on wiki.hornbill https://wiki.hornbill.com/index.php/PowerBI_Reporting. I have managed to download the R script filled in the instanceName, InstanceZone, apikey, report ID and runid, added the code in the power bi editor but it seems that's not all I have to do. Also in this arrUrl do I have to fill in the instancezone and instance name? I have attached the error when I select connect to Power bi using R script (PowerBIDataSource_HistoricReport.R ) arrUrl = c("https://", instanceZone, "api.hornbill.com/", instanceName) Is it possible to get guide(step by step guide) on how this is created please? Regards Mizeel
×
×
  • Create New...