Power BI Connection issue

Forum|Forum|2 years ago
February 19, 2024
3 replies
2391 views

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)

General Customization

A

aaronjlarson

14-Alexandrite

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

21-Topaz I

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

Marco

HelesicPetr

22-Sapphire II

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

S

SARAN

Author

12-Amethyst

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