Josh Bridgens Posted January 20, 2020 Share Posted January 20, 2020 Configured setup exactly as I have in the past with the new GitHub Text... Getting the following error message: DataSource.Error: ADO.NET: R script error. No encoding supplied: defaulting to UTF-8. Error in if (runID > 0) { : argument is of length zero Execution halted Details: DataSourceKind=R DataSourcePath=R Message=R script error. No encoding supplied: defaulting to UTF-8. Have tried switching the encoding as recommended but no luck.... Can anyone help? Ive got the big wigs breathing down my neck as to why their reports aren't working! Link to comment Share on other sites More sharing options...
Steve G Posted January 20, 2020 Share Posted January 20, 2020 Hi @Josh Bridgens, I can replicate your issue, and it's due to a problem with the API key being used. It's either been deleted, revoked, suspended, auto-expired or doesn't have the privileges required to run the report. I'll have a look at the code to see if I can return a slightly less confusing message when there are issues with the key, but if you have a look at the key you're using I expect you'll find there's an issue there. Cheers, Steve Link to comment Share on other sites More sharing options...
Josh Bridgens Posted January 20, 2020 Author Share Posted January 20, 2020 23 minutes ago, Steve G said: Hi @Josh Bridgens, I can replicate your issue, and it's due to a problem with the API key being used. It's either been deleted, revoked, suspended, auto-expired or doesn't have the privileges required to run the report. I'll have a look at the code to see if I can return a slightly less confusing message when there are issues with the key, but if you have a look at the key you're using I expect you'll find there's an issue there. Cheers, Steve Perfectly correct. Thank you so much. Josh Link to comment Share on other sites More sharing options...
Steve G Posted January 20, 2020 Share Posted January 20, 2020 Hi @Josh Bridgens, I've added some extra error handling, so you now get a more descriptive error returned when the report run API call is not sucessful for any reason: The updated scripts are up in the Github repo now: https://github.com/hornbill/rPowerBIHornbillDataSources Cheers, Steve Link to comment Share on other sites More sharing options...
Josh Bridgens Posted January 23, 2020 Author Share Posted January 23, 2020 Steve, thanks so much for the help with this. Link to comment Share on other sites More sharing options...
Mark den Elzen Posted May 27, 2020 Share Posted May 27, 2020 Hi Hope it's okay to continue in this thread, since it is related to Power BI and R Script. I am just starting with the Hornbill API in combination with Power BI. I got all the dependencies (I believe) installed with R. Copied the script from GitHub PowerBIDataSource_HistoricReport.R in the R Editor in Hornbill. Changed the Instance and added the API Key. I ended up with the error: What Am I doing wrong here? Thanks in advance for your help. Mark Link to comment Share on other sites More sharing options...
Steve G Posted May 27, 2020 Share Posted May 27, 2020 Hi @Mark den Elzen, The 404 error you are seeing suggests that the script has been able to communicate with Hornbill, but can't find the specific endpoint. This is possibly down to the instance ID provided to the script - could you double-check that please (and note, it is case-sensitive). Thanks, Steve 1 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