AndyGilly Posted June 19, 2020 Posted June 19, 2020 Hi I am having a issue getting the Historic Report R script to connect in Power BI the error is I have also installed R v4 when I switch to that installation I get the following error appreciate any guidance thanks Andy
Steve G Posted June 26, 2020 Posted June 26, 2020 Hi @AndyGilly, I've just given the R scripts a whirl through R v4.0.2, and they are working fine. The process I followed to install and configiure this is as so: Downloaded and installed R v4.0.2 from here: https://cran.r-project.org/bin/windows/base/ ; Opened RGui for the newly installed version of R, and installed the httr & readr packages (and dependencies) from within there (I used the UK - London repo, but that shouldn't matter as they are mirrored); Opened Power BI, navigated to Options and settings > Options > R scripting, and set the Detected R home directories option to the version of R that I just installed: Run the existing scripts as a Power BI data source, and they return the dataframe as expected. So I think this must be an environmental issue in your R/Packages/Power BI configuration... Could you check the above steps (2 and 3 probably being the most important) and let me know how you get on? Also, if you don't want to use R to pull data in to Power BI from Hornbill, then you could always use the (slightly friendlier) Python data source scripts to perform this. Cheers, Steve
AndyGilly Posted June 26, 2020 Author Posted June 26, 2020 thanks @Steve G really helpful and much appreciated The error msg has now moved onto a timeout, any thoughts on the below?? thanks Andy
Steve G Posted June 26, 2020 Posted June 26, 2020 Hi @AndyGilly, Looks like it's timing out when trying to retrieve your instance API endpoint details from files.hornbill.com - possibly due to a firewall or proxy getting in the way... Does the account and machine that's running Power BI (and therefore R) have access to https://files.hornbill.com/instances/YOURINSTANCEID/zoneinfo, replacing YOURINSTANCEID with your instance ID? We may need to add specific proxy support to the scripts too, I'll take a look at that. Cheers, Steve
AndyGilly Posted June 26, 2020 Author Posted June 26, 2020 @Steve G Just had a thought to whether i should be posting the instance info and url I get a success outcome returned when I try that link let me know if you would like me to send the screenshot thanks Andy
Steve G Posted June 26, 2020 Posted June 26, 2020 @AndyGilly I saw the screenshot before you removed it, and you can get to what you need fine so it's not a firewall issue. It'll likely be your proxy getting in the way, I'll make some changes to the code to allow you to provide proxy details, will let you know here once done. Cheers, Steve
Steve G Posted June 29, 2020 Posted June 29, 2020 Hi @AndyGilly, I've made the required changes, the scripts now support the use of proxies. Each script now has a number of variables that can be used to define the proxy details. If set to NULL, then a proxy will not be used. They are on Github now. Let me know how you get on with them. Cheers, Steve
AndyGilly Posted July 3, 2020 Author Posted July 3, 2020 Morning @Steve G, really appreciate the support over the last few weeks, i have this morning managed to get our system proxy to work thanks Andy 1
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