Jump to content
CalebH

Integrate Data automatically in to PowerBI

Recommended Posts

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

Share this post


Link to post
Share on other sites

Hi Caleb,

Have a read of this page in the wiki for the Hornbill Data Export Tool.  This tool will automatically take the Hornbill CSV generated reports and export them to a local database (MySQL, Microsoft SQL, MarieDB)

Let us know if you think that this will cover what you are looking for.  

Regards,

James

Share this post


Link to post
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...