cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbrandt Frequent Visitor
Frequent Visitor

Accessing tables after the Nav Table

Howdy!

 

I've been working with the Custom Data Connector and utilizing the Nav Table capabilities to allow users to refine the data selection.  I'd like to perform additional data manipulations based on the results of the user selections.  

 

For example:  My data source is web.contents and I call this to retrieve a listing of available data sets, one data set per month.  I put the list into a Nav Table and allow the user to select which data sets they want to analyze.   If the use selects three data sets, the result is three tables are loaded into the data model. 

 

I would like to append these tables into a single table within the data connector, but it appears that process control has already been passed back to PBI from the data connector.  

 

Any thoughts are much appreciated!  

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Accessing tables after the Nav Table

Hi @jbrandt,

I would like to append these tables into a single table within the data connector, but it appears that process control has already been passed back to PBI from the data connector.


As you have mentioned above, when the user see the Navigator page which contains a list of tables returned by the Custom Data Connector, the job(get custom data) of the Custom Data Connector is finished, the process control will be passed back to PBI from the data connector. So I don't think we can perform additional data manipulations based on the results of the user selections on the Navigator. Smiley Happy

 

Regards

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: Accessing tables after the Nav Table

Hi @jbrandt,

I would like to append these tables into a single table within the data connector, but it appears that process control has already been passed back to PBI from the data connector.


As you have mentioned above, when the user see the Navigator page which contains a list of tables returned by the Custom Data Connector, the job(get custom data) of the Custom Data Connector is finished, the process control will be passed back to PBI from the data connector. So I don't think we can perform additional data manipulations based on the results of the user selections on the Navigator. Smiley Happy

 

Regards

jbrandt Frequent Visitor
Frequent Visitor

Re: Accessing tables after the Nav Table

Thanks for the insight, much appreciated.  Perhaps some pre/post data connector jobs would be useful. 

 

Kind regards, 

 

John