Integrate Data automatically in to PowerBI

[CalebH]

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

[James Ainsworth]

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