Showing results for 
Search instead for 
Did you mean: 

Scheduled Dataflow with Custom Connector OR Standard Web API incl. API Key / OAuth2.0 Authentification



Like already asked for here:

I would like to be able to push some big data via Rest API (json) into my Common Data Service. I'm already able to do that with Power Automate, but here I just can do it for each record via slowly "Apply to each" loop (think about running time with over 10000 records..) and without nice Power Query options.


So I can image there some different options:


- Power Automate Flow: Flexible triggered REST APi with "Upload JSON records" CDS Action incl. Power Query ETF process

- Dataflow Web API with API Key / OAUTH2.0 Authentification

- Dataflow Custom Connection Option




Status: New