vhayer Posted March 19, 2021 Share Posted March 19, 2021 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 " 1 Link to comment Share on other sites More sharing options...
Steve G Posted March 24, 2021 Share Posted March 24, 2021 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: Note, the instance ID is case sensitive. Kind regards, Steve Link to comment Share on other sites More sharing options...
vhayer Posted March 25, 2021 Author Share Posted March 25, 2021 (edited) @Steve G Hi Steve, thanks for you're reply, this is my instance id: https://live.hornbill.com/[[INSTANCE ID]]/ I don't see anything wrong with that, perhaps I'm wrong?, thanks Edited March 25, 2021 by SamS modified link to highlight Instance ID Link to comment Share on other sites More sharing options...
SamS Posted March 25, 2021 Share Posted March 25, 2021 @vhayer, I have modified your link above to highlight the part of the URL which happens to be the [[Instance ID]] Link to comment Share on other sites More sharing options...
MattZ Posted March 29, 2021 Share Posted March 29, 2021 @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 1 Link to comment Share on other sites More sharing options...
vhayer Posted March 31, 2021 Author Share Posted March 31, 2021 @Steve G I have checked my instance ID that is all fine and in lowercase, however I am still receiving the same error Link to comment Share on other sites More sharing options...
Steve G Posted April 7, 2021 Share Posted April 7, 2021 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 comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now