Keith Posted August 8, 2017 Share Posted August 8, 2017 All, I am posting this in the hope that it will be useful to some of you. However I must state up front that the process and documentation covered in this post is the work of a colleague of mine and I am not qualified to answer any technical questions you might have. You will need to take this information at face value, we are unable to offer any support or assistance in you replicating this in your systems. Sorry! Now...We had a real need for more dynamic reporting across large data sets that we really couldn't achieve directly in Hornbill. Reading on the wiki about Power BI integration we began to look at how we could extract data from Hornbill for use in Power BI. Our global infrastructure lead was tasked with investigating and I'm pleased to say was successful in finding a solution that suits us. He has documented as best he can what he has done to achieve this which you will find attached. Hornbill Data Extraction Method.docx Below you will find some examples of the Power BI reporting we are achieving with this. As we are storing the data externally in a SQL database we are able to go beyond the 25K record limit imposed within Hornbill. 5 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now