Skip to main content
Solved

Collect NQE report Data via POWER BI

R
Spotter
Forum|alt.badge.img+2

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

Best answer by Tyson Henrie

@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

View original
    Did this topic help you find an answer to your question?

    Tyson Henrie
    Employee
    Forum|alt.badge.img+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
    Employee
    Forum|alt.badge.img+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

    davetee
    1 person likes this
    • davetee
      davetee
    R
    Spotter
    Forum|alt.badge.img+2

    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
    Employee
    Forum|alt.badge.img+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
    Spotter
    Forum|alt.badge.img+2

    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
    Employee
    Forum|alt.badge.img+1
    • GaryB
    • Employee
    • June 28, 2024

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

     

     

    R
    1 person likes this
    • R
      Rohit_809 Kumar
    R
    Spotter
    Forum|alt.badge.img+2

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

     

     

    G
    Employee
    Forum|alt.badge.img+1
    • GaryB
    • Employee
    • June 28, 2024

    @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

     

     

    R
    1 person likes this
    • R
      Rohit_809 Kumar

    Reply


    Badge winners

    • Community Champ Award
      CarlBhas earned the badge Community Champ Award
    • Community Champ Award
      Christopherhas earned the badge Community Champ Award
    • NQE Collaborator
      Rohit_809 Kumarhas earned the badge NQE Collaborator
    • Community Champ Award
      Vladi Bhas earned the badge Community Champ Award
    • Community Champ Award
      dakotagloryhas earned the badge Community Champ Award
    Show all badges

    Most helpful members this week

    Terms of UseCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings