Steve G Posted January 2, 2020 Share Posted January 2, 2020 As you may be aware, Microsoft have recently added support for Python in Power BI. So we've just released some new Python scripts that can be used as datasources in Power BI: PowerBIReport.py - this script will run a report on a specified Hornbill instance, then output the report CSV data as a Power BI consumable dataframe; PowerBIHistoricReport.py - this script will retrieve a historic report run CSV from a report on a specified Hornbill instance, then output the report data back as a Power BI consumable dataframe; PowerBIReport.py - this script will retrieve the trend data from a measure on a specified Hornbill instance, then output the trend data back as a Power BI consumable dataframe. These scripts can be found on Github, and are documented on the Hornbill Wiki. There are a number of dependencies, so please ensure you read the Wiki documentation (and pages linked on that wiki page) thorougly before attempting to implement. Thanks, Steve Link to comment Share on other sites More sharing options...
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
Already have an account? Sign in here.Sign In Now