Forum Discussion

matthias_vc's avatar
matthias_vc
Frequent Visitor
4 years ago
Solved

generate steps with custom connector

Hi All, 

 

I'm creating a Custom Data-Connector to Connect to OPC (Oracle Primavera Cloud) which has a REST Data Service.
Although I can get the Connector to summon the data, I'm a bit wary of trying to implement query folding as I think it might be too complex and I'm trying to create a light alternative for myself and a couple of my colleagues.

 Basically the Proces currently works like this:

1) The user selects a Table in the NavigationTable

2) Based on the Column Information I generate a Json Body to request the Data from the Service

3) Using this Body a Table is fetched with ALL the columns and ALL the rows

 

I would like the users to be able to see and EDIT step 2 in the query. This way a more advanced user can opt to remove some elements from the JSON or add Filters and reduce the load size significantly. However currently in Power Query only step 1 and 3 are visible.

let
    Source = OPC_Connector.Contents(),
    Activity1 = Source{[displayTableName="Activity"]}[Data]
in
    Activity1

Is it possible to generate steps inbetween so the user can edit them later on?

Alternatively, is it possible to throw in a "column selection" / "Filter Selection" step in the GetData process?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI matthias_vc,

    I don't think you can directly interact with the navigation table fields. For this scenario, you can try to add an additional parameter to your data connector that allows users to input parameters to the service side.

    In addition, you can also take a look at the following link about invoking a function from the navigation table if helps:

    Invoke a function from a navigation table · Issue #30 · microsoft/DataConnectors · GitHub

    Regards,

    Xiaoxin Sheng

    • paulciszewki's avatar
      paulciszewki
      New Member

      This is a reminder to all those P6 users that there are videos showing how to connect to an on-premise Primavera P6 Native DB at in the following LinkedIn group:

       

      https://www.linkedin.com/groups/13914226/

       

      And if you are on Oracle Hosting/OCI using P6 or OPC, Mustang developed a utility called P6ETL® that extracts the P6 and/or OPC data from Oracle via Web Services and then P6ETL® creates a reporting database (the P6ETL™ MSSQL database).  Using the P6ETL®  MSSQL database, users can create Power BI reports.

       

      We are holding webcasts on P6ETL®  in January 2023.  To learn more, go to www.p6etl.com