Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
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)
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?
Take a look at this discussion
You can also search on knowledge base using "Power BI" keyword
https://www.ptc.com/en/support/search/#q=power%20bi
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
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
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
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.