Jump to content

Recommended Posts

Posted

Hi 

I am having a issue getting the Historic Report R script to connect in Power BI

the error is

image.png.6c2e586593f84bb3d62da1d4febe12cb.png

I have also installed R v4 when I switch to that installation I get the following error

image.png.12a62a6a867ed9677128ba63bc1ae89a.png

appreciate any guidance 

thanks

Andy

 

Posted

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:

  1. Downloaded and installed R v4.0.2 from here: https://cran.r-project.org/bin/windows/base/ ;
  2. 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);
    • image.png
    • image.png
  3. 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:
    • image.png
  4. 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

Posted

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

Posted

@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

 

Posted

@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

Posted

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. 

image.png

Let me know how you get on with them.

Cheers,

Steve

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...