[Error connecting MS PowerBI]

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

[Hornbill INSIGHTS 2018]

@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!

[Hornbill Integration with Power BI]

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

[Hornbill Integration with Power BI]

10 minutes ago, Victor said:

Perhaps @Steve G might be of assistance here?  

Hi Steve, any assistance will be much appreciated.

[Hornbill Integration with Power BI]

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

 

 

[Hornbill Integration with Power BI]

Thanks Victor

 

[Hornbill Integration with Power BI]

Hi Trevor,

It looks like this

#Define Instance Details

instanceName = "Ammic"

instanceZone = "eur"

[Hornbill Integration with Power BI]

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

[Hornbill Design Interface]

Thanks Victor your help. I was able to amend the view details form in service manager under service portfolio menu -> catalogues -> request config.

[Hornbill Design Interface]

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?

[Hornbill Design Interface]

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

 

[Hornbill Integration with Power BI]

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