Connection to Microsoft Power BI
Power BI offers advanced visualizations and business intelligence functions for your valuable web analytics data. In addition, you can use Power BI to link your tracking data with other data on customers, products or campaigns, derive insights and share them with others.
To import your etracker analytics data using the web service interface (REST Report API), you only need to follow these 5 steps.
Prerequisites
- To use the etracker Rest Report API, you need etracker analytics Enterprise Edition.
- To create an access token for authentication, administrator authorizations are required, which are reserved for the main user.
Step 1: In the Power BI desktop application, click on Retrieve data.
Step 2: Select the More option.
Step 3:
Enter the name ” X-ET-Token ” in the left input field for the HTTP request header parameter, and enter the value of the access token you created for the etracker REST Report API in the right input field.
How to create an access token for the REST Report API.
In recent versions of Power BI, Microsoft has removed the fields for HTTP request header parameters from the configuration dialog by default.
To display them again, uncheck the box under:
File → Options and Settings → Options → GLOBAL → Preview Features → New Power Query Experience
Step 4: Enter the URL for the REST call in the URL parts field.
Structure of the URL for REST calls.
Step 5: Click on the OK button to import the data. Done!