Forum Discussion
Using Webtrends REST URL as a datasource
Is it possible to use a query URL generated by the Webtrends REST URL generator as a Datasource for a tile in Power BI? The url has this kind of format:
I cant see a way of doing it using Get Data and the Webtrends Connector and I cant see a way of getting to the data via a web connector (see earlier post: https://community.powerbi.com/t5/Integrations-with-Files-and/Webtrends-beta-Navigator-View/m-p/420948#M17268 )
So not sure which connector if any supports this kind of function. If any body knows can they give me an idiot guide on what to try please. Webtrends is part of my Office365 environment where I work so dont need gateways etc
Thanks Howard
9 Replies
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,
LydiaHi 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?