Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
Regards
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.
Regards
Thanks for the insight, much appreciated. Perhaps some pre/post data connector jobs would be useful.
Kind regards,
John
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |