Reporting for PowerBi and Record Limit

[David Jackson]

Hi,

I am new to Hornbill so be gentle, I have managed to use Python to pull a report from Hornbill to be used in PoweBi, which is fine. I want to be able to compare year-to-year data. Unfortunately, I am unable to pull a full year's ticket data as the limit is 25k whereas for 2023 just under 33k were logged. So I am open to suggestions on how to get all the data from last year with the additions of what's been logged this year.

I have a vision I will have to have a master sheet somewhere which has all the legacy information which I have to manually update every time I reach the limit, but like I said open to suggestions and ideas.

Thanks

 

[Steve Giller]

The short version is:

Pull 6 months' data, store this in a table locally, or even a spreadsheet.

Pull the next 6 months' data, and then add that to the table/spreadsheet.

[Gerry]

@David Jackson

Basically exactly what @Steve Giller says, page the data out.  If there is too much data for 6 months, try three, or one for each month of the year, consolidate the results in your working data sets.  

[David Jackson]

Hi All, 

Thanks for the input, so yes I am exporting data to a spreadsheet for historical information and then using a Python script to pull current information.