Power BI Connection issue

[SARAN]

Hi Team,

I have unable to access the Power BI report from Windchill qml report. I tried to access error message " string reference not set to an instance of a string. parameter name: s" is occurred. If without sso system url able to access. Any one known this behavior?

Winchill Version: 12.0.2.13. Power BI Version: 2.124.2028.0 64-bit (December, 2023)

[aaronjlarson]

What is the method in PowerBI that you are using to connect to the QML report? And what exactly do you mean when you say you're "accessing" the Windchill QML report?  Do you have parameters defined in either the PowerBI or Windchill report side?

[Marco_Tosin]

Take a look at this discussion

BI Tools and Windchill

You can also search on knowledge base using "Power BI" keyword

https://www.ptc.com/en/support/search/#q=power%20bi

[HelesicPetr]

Hi @SARAN 

Why do you not use the direct connection to a database and use database queries ?

btw what method do you use to get data from QML report? WRS API ?

How do you define it ?

PetrH

[SARAN]

Hi HelesucPetr

We have could system. That's why not having the database access. 

I have user get web method to execute the data.  The below URL was used

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

[HelesicPetr]

Hi @SARAN 

If you send a HTTP request, you have to define the login information to that request 

You can try WRS to get report template results  

Check this article

CS254366 - Windchill REST Services (WRS)

Windchill Resources

https://windchilladress/Windchill/netmarkets/html/wrs/doc.html

PetrH

[SARAN]

Hi HelesicPetr,

Thanks for the sharing.

This is Post request , But above shared url is working fine in without SSO system. I have send the basic credentials only. 

Get request is works. if same steps followed above shared error have appear.