Power BI integration with Windchill

[AD_9933743]

Hey everyone,

I am a beginner with Windchill and have a question about getting query data from the PTC Windchill server and directly pushing the information to Power BI.

I've been doing some research and have seen some other posts on this website mentioning the use of the REST API, however I have not seen a definitive solution to this.

My question is if anybody has done this integration if they can share how they have done it or give me some pointers? 

Thanks in advance.

[rhart]

Hi @AD_9933743 

That's a great idea, you can pull data from Windchill into PowerBI using REST Services and you can do the same in MSExcel etc.

1. Start with a blank web query in PowerBI

Start with a blank web query in PowerBI

2. Use the Advanced Editor to write web query from scratch

Use the Advanced Edit to write a web query from scratch

3. Only need to call the REST Service (using an OTB odata REST here) and provide an authentication

Make your REST call and provide Authentication

let
    Source = Json.Document(Web.Contents("https://<myhost>:80/Windchill/servlet/odata/v5/ChangeMgmt/ChangeNotices?%24count=false", [Headers=[Authorization="Basic <mybasicauth>"]]))
in
    Source

4. Transform and present the data how you want in the PowerBI UI

How would go about having a REST endpoint push? Once it's in Power BI you can refresh to pull the latest data anyway.

Main downside to this method is storing credentials in the pbi web query, if you want to share the analysis then publish it, instead of sharing the Power BI file itself

[TomU]

How are you generating that basic auth hash?

[rhart]

I followed this post more or less

https://community.ptc.com/t5/Windchill/BI-Tools-and-Windchill/m-p/589122#M58699 

[AD_9933743]

Thank you so much for your detailed response @rhart !

Like @TomU I am also wondering where you generated the basic authorization hash key from. I seem to not be able to find it in my PTC Windchill web client. Also, when utilizing the odata REST service, is there any sort of setup required? Or is the functionality built into Windchill? Any help would be much appreciated.

Thanks!

[rhart]

Just whichever browser you prefer in dev mode can find it, following the hints in the link above.

Log in to Windchill then try the REST Service url in the address bar using a tab in the same session, if you get a json file back, REST is already setup.

[SM_10639755]

I try this but is not working, maybe is it just me? any additional tip? 

Thanks