Data Explorers: Exporting Query Results
When you have built a query for your Usage, Billing, or Prepayments data in m3ter using a Data Explorer, you can export the data returned for the query as a .csv file. This topic explains how to export your query results data from the Data Explorers.
Notes:
Usage Data Explorer - example export. The following procedure explains how to export Usage data query results in the original version Usage Data Explorer. You can follow similar steps to export your Billing or Prepayments query results.
Usage Data Explorer (v2). If you're working in Data Explorer (v2), you can export query results data directly from the Result rows table. See Usage Data Explorer (v2) for details.
To export query results:
1. Select Metering>Usage Data Explorer.
2. In the Usage query builder, configure a query, perform the query, and review the returned data in the Data Table tab.
3. On the Data table tab, select Export. The returned data set is compiled in .csv formatted file, downloaded, and saved locally.
Warning: Number of Rows for Export! If you download query results in a .csv formatted file, the number of rows is limited to 20001.
Tip: Exporting Prepayments Query Data? If you're exporting Prepayments query data, the Export button is on the Prepayments - Table tab.
Additional Support
Login to the Support portal for additional help and to send questions to our Support team.