generate steps with custom connector

[matthias_vc]

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?

[Anonymous · Accepted solution]

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]

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