Collecting Windchill Tasks For Each User

[CR_10056409]

I am trying to collect all open Windchill tasks for each user so I can link power bi and make some tables.

I found that I can use https://<host>/Windchill/servlet/odata/ChangeMgmt/ChangeTasks to get my tasks but I want my tasks plus everyone else's so I can neatly show the data of the open tasks.

Has any come across a solution for this?

[avillanueva]

What about using the Open Tasks report using Query Builder? I forget if that one is OOTB but can be easily imported if you need it.

[CR_10056409]

Thank you for the response, that works but the only problem is I would have to continually grab the report and import it into Power BI.  My goal is to be able to just refresh the power BI dashboard and have the data update if that makes sense

[avillanueva]

Its possible to pull the report into Excel via and have it pull down data by refreshing. Its how I do all my complex metrics reporting. I pull 4 reports and combine. Does Power BI have the ability to pull data from a web query?

[CR_10056409]

It does have that ability but I am struggling to get it to work because it requires anonymous credentials which my URL is not agreeing with.

[CR_10056409]

I was able to get the authorization to work but Power BI was unable to get information from te web page

[avillanueva]

Ensure that the report is defaulting to render as an HTML page. The new style of reports has a left slider that accepts query input. By forcing to old style and HTML, it just displays and you can select the table to import. This can be done with the right parameters in the URL.

https://<your host.com>/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/URLTemplateAction?format=formatDelegate&delegateName=HTML&xsl1=&xsl2=&oid=OR%3Awt.query.template.ReportTemplate%3A1488903795&action=ExecuteReport

[avillanueva · Accepted solution]

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-importing-and-analyzing-data-from-a-web-page

[SARAN]

Hi , 

I am tried this same it is working fine without SSO system, If SSO enabled system the URL is not working. the below error message is occurred. Any thing need to be provide some details?

 Can you help on to resolve this.?

[HelesicPetr]

Hi @SARAN 

You need to solve the issue with your SSO system provider. 

PetrH

[SARAN]

yes

[HelesicPetr]

So , you need to contact a person in your organization who is responsible for the SSO.

PetrH

[SARAN]

Hi HelesicPetr,

Any parameter additionally send to this URL? Do you have any idea on this.