Jump to content

Recommended Posts

Hi I am trying to establish a connection to Power BI following the instructions via Github, however keep receiving the below error when running the R scrip, any help? @Steve G your input would be much appreciated, thanks

Details: "ADO.NET: R script error.
Error: lexical error: invalid char in json text.
                                       <!DOCTYPE HTML PUBLIC "-//IETF/
                     (right here) ------^
Execution halted
"

 

 

  • Like 1
Link to post
Share on other sites

Hi @vhayer,

That error is likely due to an incorrect value in the instanceName varible (row 2, attached), meaning that the script can't access your instance details to proceed:

image.png

Note, the instance ID is case sensitive.

Kind regards,

Steve

 

Link to post
Share on other sites

@Steve G I have the same error msg as above. 
Unable to connect 

Details: "ADO.NET: R script error.
Error: lexical error: invalid char in json text.
                                       <!DOCTYPE HTML PUBLIC "-//IETF/
                     (right here) ------^
Execution halted
"

----

#Define Instance Details
instanceName = "https://live.hornbill.com/*******/"   (All lowercase) 
apiKey = "****************"  sys admin api key

# Define Report details
reportID = "64"
reportRunID = "56"
useXLSX <- FALSE # FALSE = the script will use the CSV output from your report; TRUE = the script will use the XLSX output from your report

# Settings for using XLSX report output
# You must have XLSX output enabled against the target report in your Hornbill instance to use these settings
deleteLocalXLSX <- FALSE  # FALSE = the downloaded XLSX file will remain on disk once the extract is complete; TRUE = the local XLSX file is deleted upon completion
xlsxLocalFolder <- ""     # Can be left blank, or specify a local folder to store the downloaded XLSX file into. Requires the postfixed / or \ depending on your OS
 

 

  • Like 1
Link to post
Share on other sites

Hi @vhayer and @MattZ,

Apologies for the delay in responding, I've been on annual leave. The issue here is that you're providing the entire URL to the web frontend for your instance in the instanceName variable, instead of just the instance name.

So for example, if your instance was called myinstance, you are currently setting:

instanceName = "https://live.hornbill.com/myinstance/"

When this should actually read:

instanceName = "myinstance"

Hope this helps,

Steve

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...