IMPORTANT - Power BI R Script Updates!

[Steve G]

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:
  • 
• 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

[chriscorcoran]

Hi @Steve G I have given it a try today but getting  error below. I noticed the report seems to be still trying to output as csv even though I selected xlsx, thanks

 

[chriscorcoran]

script attached, im using minus instance and key

hornbill script.txt

[Steve Giller]

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

[chriscorcoran]

@Steve Giller not sure if its officlally been fixed but I have switched back to csv using the latest R script and my dashboards are now updating OK. Thanks.