Skip to main content
Solved

Collect NQE report Data via POWER BI

  • 25 June 2024
  • 8 replies
  • 65 views

How can i collect NQE Query Data from Forward Network to Power BI Easily,

8 replies

Tyson Henrie
Rank
Userlevel 4
Badge +1

@Rohit_809 Kumar The NQE API can return the results in a JSON format.  That is generally the most common way to share the data between platforms.

https://fwd.app/api-doc#nqe

This is a POST API call.  In the Body of the API you can specify the queryId of the NQE query that you want results from.  It will return as json.

Tyson Henrie
Rank
Userlevel 4
Badge +1

@Rohit_809 Kumar I found a Microsoft post showing how to ingest JSON from a RESTAPI.  The example is not Forward Enterprise.  However, the ingestion of JSON from RESTAPI is the same.

https://community.fabric.microsoft.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400

R
Rank
Userlevel 1

thanks  Tyson Henrie, i am able to reach and get the all NQE Query id , but not able to fetch the data that NQE query show.

 

 

 

Tyson Henrie
Rank
Userlevel 4
Badge +1

Here is an example:

 

POST https://fwd.app/api/nqe?networkId={networkId}

<body>

{

  “queryId”: “FQ_6ac3682c92a74b778d98584aea8afa5fe40f2150”

}

</body>

 

I usually use Postman to test with. You should receive a JSON response to this.

R
Rank
Userlevel 1

thanks @Tyson Henrie , for the help ,

 

we write the some queries ,but we are not able to see the Query id filed those q we write.

G
Rank
Userlevel 4
Badge +1

@Rohit_809 Kumar QueryId can be found under the (i) next to the query name in Forward NQE Library

 

 

R
Rank
Userlevel 1

those NQE write by us , i am not able to see Query id on those.

 

 

G
Rank
Userlevel 4
Badge +1

@Rohit_809 Kumar You should be able to see the same dialog on any query in your Org Repository. IF you don’t see the query it is possible that the author has not committed the query so it is visible to everyone. 

Check that the query is committed into the Library, then it will be visible to obtain the queryId

 

 

Reply


Badge winners

  • Community Champ Award
    GaryBhas earned the badge Community Champ Award
  • Community Champ Award
    AndyLhas earned the badge Community Champ Award
  • NQE Contributor
    Christopherhas earned the badge NQE Contributor
  • NQE Contributor
    Tyson Henriehas earned the badge NQE Contributor
  • NQE Contributor
    Nandhas earned the badge NQE Contributor
Show all badges
Terms of UseCookie settings