Jump to content

IMPORTANT - Power BI R Script Updates!


Recommended Posts

Good afternoon,

We've just released v1.7.0 of the R scripts that are used to pull data from Hornbill Reporting into Power BI. The Report and HistoricReport scripts now support the use of XLSX files in the output of Hornbill reports, as well as the existing CSV options.

The updated scripts can be downloaded now from Github.

As always, please review the wiki documentation for the changes, but as a very basic overview:

  • XLSX output needs to be enabled against your target report configuration:
    • image.png
  • useXLSX needs to be set to TRUE in the scripts for them to target the XLSX file in the report output rather than the CSV file;
  • When useXLSX is TRUE, the readxl package is required to be installed on the machine running the scripts.

Thanks,

Steve

Link to post
Share on other sites

@chriscorcoranDid you complete the 

On 11/12/2020 at 12:51 PM, Steve G said:
  • useXLSX needs to be set to TRUE in the scripts for them to target the XLSX file in the report output rather than the CSV file;
  • When useXLSX is TRUE, the readxl package is required to be installed on the machine running the scripts.

steps?

Looks like useXLSX is FALSE in the script.

Link to post
Share on other sites
  • 2 weeks later...

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