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?
Solved! Go to Solution.
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
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?
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.
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.