Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Custom Connector - How to manipulate existing data from navigation table

Hi,   I've built a custom connector with a OAuth2 authorization code flow. The custom connector retrieves data from a REST API. My goal is to manipulate data based on the result of the REST request...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

 

Then, the custom connector should add, update or delete the specified record to the dataset.

 

Any connector, be it custom or not, is confined to the "flush and fill"  paradigm.  Power Query presents a table to Vertipaq, and Vertipaq incorporates that table in its data model.  That's it.  No adds, deletes, or updates.  Just flush and fill.  (ignoring self referencing datasets for a second).  Even incremental refresh is fundamentally flush and fill, just on partition level rather than table level.

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41