Mea Wiki - Recent changes [en]

Connecting Microsoft Power BI to QPR Web Service

TeeHiet — Wed, 20 May 2026 09:36:33 GMT

Querying Navigator View Contents

File:NavigatorViewInPowerBI.png

TeeHiet — Wed, 20 May 2026 09:31:57 GMT

TeeHiet uploaded File:NavigatorViewInPowerBI.png

New page

Connecting Microsoft Power BI to QPR Web Service

TeeHiet — Wed, 20 May 2026 09:27:47 GMT

Querying Navigator View Contents

File:ServicetesterResults.png

TeeHiet — Wed, 20 May 2026 09:24:26 GMT

TeeHiet uploaded File:ServicetesterResults.png

New page

File:ServicetesterNavigatorViews.png

TeeHiet — Wed, 20 May 2026 09:15:45 GMT

TeeHiet uploaded File:ServicetesterNavigatorViews.png

New page

Connecting Microsoft Power BI to QPR Web Service

TeeHiet — Wed, 20 May 2026 09:12:25 GMT

@@ Line 87: / Line 87: @@
 == Querying Navigator View Contents ==
-Querying a navigator view's contents is done in two steps.<br>
+Querying a navigator view's contents is done in two steps. Note that, as with the Simple Query example, you need to define the URL of your QPR server to the authUrl and dataUrl, and give a valid username and password as values to logOnName and password.<br>
 . Query the navigator view settings. It's advisable to do this with the servicetester, as you won't use this query in Power BI.
 * Query: [PG.1374444994].HierarchyRoots(hierarchy="navigatorviewsettings")
@@ Line 168: / Line 168: @@
      FinalResult
 </pre>

@@ Line 87: / Line 87: @@
 == Querying Navigator View Contents ==
-Querying a navigator view's contents is done in two steps.
+Querying a navigator view's contents is done in two steps.<br>
-# Query the navigator view settings. It's advisable to do this with the servicetester, as you won't use this query in Power BI.
+. Query the navigator view settings. It's advisable to do this with the servicetester, as you won't use this query in Power BI.
-#* Query: [PG.1374444994].HierarchyRoots(hierarchy="navigatorviewsettings")
+* Query: [PG.1374444994].HierarchyRoots(hierarchy="navigatorviewsettings")
-#* Attributes: id, name, columns, columnnames
+* Attributes: id, name, columns, columnnames
-# Query the full hierarchy in Power BI, with child elements as attribute using the columns attribute list from the previous servicetester query. In this example, the "Risks" navigator view in the Dentorex example model is queried.
+[[File:ServicetesterNavigatorViews.png|thumb|none]]
 <pre>
 let
@@ Line 117: / Line 121: @@
      sessionId = sessionIdJson[d],
-     // 3. Define Query and Attributes. We got the Attributes from the Servicetester query.
+     // 3. Define Query and Attributes. Attributes are the columns from the Servicetester query.
      AttributeString = "RiskSubCategory.values,name,description,RiskOwner.values",
      QueryString = "[PG.1374444994].HierarchyRoots(viewsettings=""Risks"").Related(viewsettings=""Risks"", recursive=true, keeporiginals=true)",

@@ Line 1: / Line 1: @@
 The following is an example Power BI query that allows you to connect to the QPR MEA Web Service and import data. It first authenticates with the service to obtain a session ID, and then uses that session to query for specific data. The example query retrieves a list of all QPR EnterpriseArchitect/ProcessDesigner models, including their names and full IDs. This example requires that QPR Authentication is enabled on the server and that the user account used for authenticating is allowed to access the Web Service and data.
@@ Line 9: / Line 11: @@
          authUrl,
+         [
-             Headers = [#"Content-Type"="application/json"],
+             Headers = [
              Content = Text.ToBinary(authBody)
+         ]
@@ Line 63: / Line 68: @@
-== How the Query Works ==
+=== How the Query Works ===
 The query performs the following steps:
 * '''Authentication''': The query sends a request with a username and password to the QPR Web Service authentication endpoint.
@@ Line 70: / Line 75: @@
 * '''Data Processing''': The query receives the data in JSON format, parses it, and transforms it into a structured table with columns for each requested attribute.
-== How to Use and Customize the Query ==
+=== How to Use and Customize the Query ===
 To use this query in Power BI, you will need to copy the M code into the Power BI Advanced Editor. You must customize the following parameters to match your specific QPR environment and data requirements:
 * '''authUrl''': The URL for the QPR Web Service authentication endpoint. Replace "https://<your hostname>/<QPR version>/Portal/QPR.Isapi.dll/wsforward/MainService.svc/webHttp/Authenticate" with the URL of your QPR server's authentication service.
@@ Line 80: / Line 85: @@
 After customizing these variables, the query will connect to your QPR instance, retrieve the specified data, and load it into Power BI as a table for reporting and analysis.