Search the Community
Showing results for tags 'powerbi'.
Found 2 results
Hi All, I've been working on PowerBI recently and really like the way you are able to pivot on data points. As all our calls/tasks are managed through Hornbill, I was wondering if there was a way to output this data automatically in to PowerBI. I currently have reports generated monthly as a pdf and understand I can change this to CSV, then upload it to PowerBI which would work but I would like to automate it more than this - rather than have to upload it manually. As I understand it, Hornbill backend is an SQL database so if there was a way to point PowerBI at this to pull from (possibly using Ibridge api?) or maybe point it towards the database where reports are kept prior to it being emailed out, that would work. These were just my ideas how it could be achieved, not all to familiar so if there was any suggestions or answers to how I might do this. That would be really appreciated. Thanks in advance! Caleb
INTEGRATION: Integrating with Microsoft Power BI Although we provide powerful analytics, dashboards and reporting capabilities built into the Hornbill Platform, that capability only caters for reporting on data held within Hornbill. We know that customers often need to report across data sets from multiple systems which is where Business Intelligence tools come in. Many of our customers have requested integration with Microsoft Power BI Data Visualisation Tool, it’s a simple yet powerful tool that allows you to manipulate and visualize data sets, linking and cross-referencing multiple data sets, even data sets from different systems creating dashboards with drilldown capabilities. Microsoft has set a new benchmark in the BI space because not only is this tool powerful, there is a free edition and Pro subscriptions start at a mere $9.99/user/month which is not very expensive considering what you get for your money. We have created an integration between Hornbills Analytics Engine and Power BI which is essentially a data source provider to Power BI. The integration its self is developed in “R” and we have made this available as an open source project under the Hornbill Community License (HCL), the integration is provided completely free of charge, and we can even help you set it up if you need us to. The integration can be downloaded from our GitHub here You can find out more about this integration by watching the video attached to this post or by viewing our documentation here or searching our community forums If you have suggestions for other integrations with Hornbill please let us know, we are on a mission to be the most well connected Service Management and Business Collaboration platform on the planet!