Power BI connection issues

[Lee Jones]

Hi

I'm completely new to Power BI but I want to bring in some Hornbill data and combine this with our service desk telephony data and other sources, to produce some reporting in one place.

I've followed the instructions outlined in the Wiki article below, however I am having difficulty establishing a connection.

https://wiki.hornbill.com/index.php/PowerBI_Reporting

The error I get is as follows;

Details: "ADO.NET: R script error.
Error: package or namespace load failed for 'httr' in loadNamespace(j <- i[[1L]], c(lib.loc, .libPaths()), versionCheck = vI[[j]]):
 there is no package called 'R6'
In addition: Warning message:
package 'httr' was built under R version 4.0.2 
Execution halted
"

Can anyone point me in the right direction so I can establish a Hornbill connection to Power BI?

Many thanks

Lee

 

[Steve G]

Hi @Lee Jones,

This is an issue with the R packages on the machine where you're running R and Power BI. The error is stating that the R6 package (which is imported by the httr package that the script uses) isn't available on your machine. I'd suggest re-installing httr from the CRAN repository, and if you get the same error then manually install the R6 package within your R package manager.

Cheers,

Steve