rejish.varghese

I found it.. I believe I got everything. Thanks a lot for your help

I believe I got all the data as I needed. One last thing. Where is the department column stored? is it in the same requests table

I tried this time using Service Manager as requested but I cant see the table called h_itsm_requests. Please see below

I tried the same and couldn't find the table h_itsm_requests. Please find attached screenshot which will show all tables that start with h_i and there are none which shows h_it . Does that mean I dont have relevant permissions to see those tables? Or am I doing something wrong? Hornbill_Screenshot.docx

I was under the impression that the best way of integrating hornbill with PowerBI was to use Python/R and use reports so that we can create reports/dashboards in PowerBI. But if that is not what you recommend and we are supposed to use other ways of integration, please let us know.

I have exported the whole data from the service manager requests from Hornbill using export list and its less than 7k number of rows so its not huge but if the tool doesn't allow to export that much data, is it possible to export based on date filter (for e.g last 1 year or last 6 months or even last 3 months).

Sorry I am new to Hornbill especially reports. I am trying to create a new report which will show all service manager requests from all teams. I have a view already created called AFH Tickets and I want the same columns available in the report so that I can execute the same report id using Python script and have the data in PowerBI. I have managed to invoke different report id from PowerBI and I can see the data in PowerBI so I have managed to make that work. If you can help me in creating the report, then I am good to go.