Power BI integration with Windchill

Question

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 · Answer

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

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded