If your Printix Home is from before 2019-10-07 you may have experienced that no data is extracted since that date. A data extract that fails can be seen as follows:
- On the Analytics tab on the Settings page the Last data extract will for ever show Working on it.
- Open History, select System to filter on these events, and then as you browse through the events you will see: Data extract started by Printix System - Failed.
On 2019-10-07 Printix started to record Azure AD users’ Department, so this can be used to post process data for subsequent departmental billing. The Users - Overview page in the Power BI Report version 1.3.1 has been updated to show department. See also: Version 1.3.1 release note on Github.
The reason the data extract fails is most likely a lack of permissions for the database user. Please ensure the user has ALTER TABLE permission on the Users table.
- Adjust the permissions of the database user to allow ALTER TABLE.
- Alternatively you can add the Department column manually.