How to Create a Report in Data Explorer

How to Create a Report in Data Explorer

Data Explorer is a valuable tool that can be used to create reports for export to BigQuery or FTP , to test out a connection, or even to create a CSV file. This tool is available to all Power My Analytics customers and is included in the cost of your plan. Follow the instructions in this article to get started with Data Explorer.

Begin in your Hub.

Select Data Explorer from the left navigation pane and then +Add Report.

Name the report, then choose the options you want on the configuration screen.

Each scheduled refresh will overwrite your existing data. Choose a Custom Start option under Date Range to accumulate data over time. Fixed time frame options like Last 7 days will export only the most recent 7 days of data with each refresh.

Select Preview to look at the report and make any changes you need before saving.

Click Save when you are ready. Your report will be saved to the Data Explorer section of your hub and can be viewed or deleted at any time.

Manage Groups

You can create several reports and export them as a group. To create or manage groups, click the blue pencil icon.

Enter a name under Group Name, then click Create.

Use the drop-down box to the left of your report name to assign the report to a group.

Export to FTP or BigQuery

Follow the instructions in these articles to create your exports.
  1. How to Export to BigQuery
  2. How to Create an FTP Export

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • BigQuery Export Limitations

        Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will show you how to identify and correct errors with your BigQuery exports. Export Limitations If you are using connectors other than ...
      • How to Create an FTP Export

        FTP can be a valuable way for Enterprise users to export their Data Explorer reports. In this article, we will walk you through creating an FTP export, including selecting an FTP destination, scheduling data refreshes, and managing your exports to ...
      • How to Export to BigQuery

        Once you have a report ready in Data Explorer, you are able to export it to BigQuery. This export option is included in the Enterprise plan. Follow the instructions in this article to get started. Grant Required Roles and Permissions A successful ...
      • How to Export to MySQL

        Our MySQL export feature enables flexible access to your data in the form of tables in a MySQL database hosted on the server of your choice. Once you've prepared a report in Data Explorer, you're ready to export your data to your MySQL server. With ...
      • Error: Missing BigQuery Scopes

        This article will address the following error: Missing BigQuery Scopes Cause You may receive this error when connecting to a BigQuery account. It is a result of insufficient permissions granted to Power My Analytics. Solution Step 1: Disconnect ...