
Announcements
I'm trying to pull distinct data from a large data set using a third party connector into my Dataverse table using a Dataflow. I would need the flow to run at least once a day. The problem is I need to pull the keys to the larger dataset from my Dataverse table first and then I'm doing a merge in the third party connector query. I am using Dataverse and Dataflow in Teams.
When setting up the dataflow I started with the Dataflow connection which is available as a source.
The problem is when I select my Teams Dataverse table I get the following message:
I was able to set up my Dataverse table as s source using the OData method, however, it creates a new Dataverse table of the key column (the output from my query within the dataflow).
Is there a better way to do this? If not, does the query need to create a new Dataverse table?
Thanks in advance for any help!