cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hobe1 Regular Visitor
Regular Visitor

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:

 

https://ws.webtrends.com/v3/Reporting/profiles/<Your query code> format=html&suppress_error_codes=tr...

 

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/42094...

 

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 9
Moderator v-yuezhe-msft
Moderator

Re: Using Webtrends REST URL as a datasource

@hobe1,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hobe1 Regular Visitor
Regular Visitor

Re: Using Webtrends REST URL as a datasource

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:

 

https://ws.webtrends.com/v3/Reporting/profiles/106389/reports/8CsGJZVp4s7/?totals=all&start_period=c...

 

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?

 

Navigator.png

hobe1 Regular Visitor
Regular Visitor

Re: Using Webtrends REST URL as a datasource

I should also add if I paste the report URL into a browser it retrieves and displays the report data perfectly

Moderator v-yuezhe-msft
Moderator

Re: Using Webtrends REST URL as a datasource

@hobe1,

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=c...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
hobe1 Regular Visitor
Regular Visitor

Re: Using Webtrends REST URL as a datasource

Hi 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

 

webconnector1.png

 

On pressing OK Got the following error message:

 

Webconnector2.png

 

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

Moderator v-yuezhe-msft
Moderator

Re: Using Webtrends REST URL as a datasource

@hobe1,

I note that the Webtrends supports basic authentication, you can try to specify authentication in Headers and use Power Query code to connect to the data source. There is as similar thread for your reference.

http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hobe1 Regular Visitor
Regular Visitor

Re: Using Webtrends REST URL as a datasource

Hi Lydia,

 

OK So I think you are suggesting that I have to pass my Username and Password as parameters within the Get Data conversation using the web connector, which makes sense. I can enter parameters using the "Advanced" option however there are a bewildering number of parameters and I am not sure which parameter to use to pass my Webtrends Logon Username and Password, Can you help with that? I have enclosed a screenshot below that shows the relevant connector configuration box I am trying to complete. Each Parameter can only be used once so that scuppered my initial try which was to pass two separate parameters, Username and Password as Authorisation parameters

 

Web Connector (Advanced).pngNot sure which parameters to use to pass my username and password?

 

So I guess the crucial question is:

 

How do I pass my logon credentials to the https://generator.webtrends.com/logon site using the web connector so that it will return the results of my datasource REST URL query?

 

 

hobe1 Regular Visitor
Regular Visitor

Re: Using Webtrends REST URL as a datasource

Hi, Can anyone help with this?

hobe1 Regular Visitor
Regular Visitor

Re: Using Webtrends REST URL as a datasource

Still no response to this query?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors