Forum Discussion
Using Webtrends REST URL as a datasource
Anonymous,
What kind of query code do you refer to ? Based on the following articles, you should add profile ID after "https://ws.webtrends.com/v3/Reporting/profiles/", what is the result do you get when entering Webtrends REST URL in Web connector of Power BI Desktop?
https://help.webtrends.com/legacy/en/dxapi/api_description.html
https://kb.webtrends.com/articles/How_To/How-do-I-Generate-a-REST-URL-Data-Extract-DX-v3
Regards,
Lydia
Hi Lydia,
Thanks for the prompt reply to (both) my webtrends questions. Regarding this one the full URL for the report I am interested in using as a datasource is:
Apologies I didnt put the full URL into my original post but as you can see the URL does have the profile name in it as you mentioned.
Using Get Data and selecting the Webtrends connector in Power BI takes me directly to the Navigator table view there is no opportunity that I can see to to enter a user defined report URL querylike the one described earlier unless I am missing something?
I should also add if I paste the report URL into a browser it retrieves and displays the report data perfectly
Anonymous,
What is the result when you enter the URL below into web connector of Power BI Desktop?
https://ws.webtrends.com/v3/Reporting/profiles/106389/reports/8CsGJZVp4s7/?totals=all&start_period=current_hour-1&end_period=current_hour&period_type=agg&format=html&suppress_error_codes=true
Regards,
LydiaHi Lydia,
Sorry for delay in replying it was a bank holiday in the UK. The Web Connector didnt work for me either result below
In Power BI
Used GetData and Web Connector (basic) copy and pasted query url
On pressing OK Got the following error message:
The Edit option allows me to choose a different data format but as the output from webtrends is HTML this option is no use to me.
So still have no solution to my problem