Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The WebtrendsAnalytics.Tables function returns a table with relevant Webtrends data.
Summary
| Property | Value |
|---|---|
| Connector |  Webtrends Analytics |
| Products | Power BI (semantic models) Power Query Online |
| Release state | Preview |
| Authentication kinds | Basic |
| Data source kind | WebtrendsAnalytics |
| Function Reference Documentation | WebtrendsAnalytics.Tables |
Supported capabilities
Entry point: WebtrendsAnalytics.Tables
Parameters
Entry point: WebtrendsAnalytics.Tables
Required parameter count: 3
Enter the Profile ID associated with your Webtrends account.
Returns a table with relevant Webtrends data.
| Parameter | Display name | Required | Type | Description | Allowed values | Sample values | Nullable | Declared allowed values |
|---|---|---|---|---|---|---|---|---|
| ProfileId | Profile ID | Yes | text | You can find your Webtrends Profile ID in the URL when you are navigating Webtrends. If the URL looks like https://analytics.webtrends.com/analytics/spaces/116717/profiles/98765#%7B%22Profile... then your Profile ID is 98765. | "98765" | false | ||
| Period | Period | Yes | text | Designating use of a Custom Date range (the Start and End Date) or Standard Report period (Start and End Period). Only the start and end times for the period type selected here will be processed. | "Custom Date"; "Report Period" | false | ["Custom Date", "Report Period"] | |
| reportType | Report Type | Yes | text | The options are Summary (aggregated for the selected time period), Trend (data trended as if for a graph), and Individual (listing out each day separately). If Trend is selected on a multi-dimensional report, only the first dimension will be returned. | "Summary"; "Trend"; "Individual" | false | ["Summary", "Trend", "Individual"] | |
| startDate | Start Date | No | nullable date | Earliest date to include in data (default is 30 days ago) | "01/01/2020" | true | ||
| endDate | End Date | No | nullable date | Latest date to include in data (default is today) | "01/01/2020" | true | ||
| startPeriod | No | nullable text | Earliest standard report period to include (default is the current_month-1). For allowed values see: https://product.webtrends.com/dxapi/api_description.html | "current_month-1" | true | |||
| endPeriod | End Period | No | nullable text | Latest standard report period to include (default is the current_month). For allowed values see: https://product.webtrends.com/dxapi/api_description.html | "current_month" | true |