Collecting Windchill Tasks For Each User

Forum|Forum|3 years ago
September 8, 2022
2 replies
4294 views

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?

Other

Best answer by avillanueva

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

avillanueva

23-Emerald I

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.

C

CR_10056409

Author

4-Participant

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

23-Emerald I

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?

S

SARAN

12-Amethyst

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.?