Jump to content

Python and Power BI


Recommended Posts

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

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