Reports are essential tools for administrators managing fleets of devices. They transform complex data into visual formats, making it easier to identify trends, inefficiencies, and recurring issues. This clarity enables IT teams to proactively address problems, optimize resource allocation, and ensure system reliability.
Exporting Data for tools like Power BI
We’ve made it easy to export data from Addigy to be used with the most popular Business Intelligence (BI) tools in the market such as Microsoft’s Power BI.
Addigy has a new integration with Google Cloud’s BigQuery that automatically exports different Addigy datasets into your BigQuery system. BigQuery can then be used as a source for all popular Business Intelligence tools.
How to set up a data export to BigQuery
To get started, make sure you have these requirements:
- Your Addigy role has the permission “Export Report Data”
- A Google Cloud Platform account (GCP)
- A Service Account Key from GCP with role "BigQuery Admin"
To create a new Data Export:
- Navigate to Dashboards > Data Exports
- Click the button to create a new export
- Follow the instructions to upload the Service Account Key
- Select the Addigy datasets to include in the export
- Make sure you enable the integration by clicking the toggle
- Save
After completing these steps you will be able to see new BigQuery tables built within the Dataset that you selected. The table names will be prefixed with addigy_, for example: addigy_device-audits. Each table will have a column named export_date that indicates the date in which the data was exported from Addigy into BigQuery. Addigy will export data once a day starting from within an hour of the integration being enabled and every consecutive day within one hour of 12AM UTC.
These tables are partitioned on the export_date field, which makes it optimized for querying based on this date in order to make the queries cheaper and faster. Addigy will not remove any data from these tables; it is up to you to make sure that the tables are maintained in accordance with your own data retention policies and requirements.
Accessing Data From Power BI
- On PowerBI Desktop, start a new project or open an existing project
- In the Home navigation bar, click on “Get Data” > “More…”
- Search for “BigQquery”, select “Google BigQuery”, and click “Connect”
- Click “Ok” and follow the instructions on the screen to authenticate to your Google Cloud Platform account
- Click “Connect”
- Select the Project > Dataset > Tables you wish to use within PowerBI and click “Load”
- On the “Connection settings” prompt we recommend you toggle the DirectQuery option so that you are always looking at the most recent data and don’t have to worry about refreshing local data.
After these steps you should have the BigQuery tables available in your Data menu to be used in your reports.