cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Dataflows - Authentication using API Key or OAuth 2.0

Dear community users,

 

I try to use Dataflows to get the data from REST API (OData or OpenAPI) into the CDS.

The problem I face is that for 1 particular API, it just supports API Keys or OAuth 2.0

 

From the PowerApps, I can connect to that API from the Custom Connector, which supports API Keys and OAuth 2.0.

 

However from the Dataflows, I cannot authenticate, since there is no authentication method using API Keys and OAuth 2.0. 

 

Anyone can help on this:

  • Any information whether Dataflows will support API Keys and OAuth 2.0?
  • Do you have any other workaround to get the data into the CDS from a REST API (OData or OpenAPI) data source?

Thanks.

 

Below are screenshots from the Dataflows Settings UI, only showing Authentications Mode

  • Anonymous
  • Basic Authentication
  • Windows
  • Organizational Account

 

With Gateway

API Endpoint with GatewayAPI Endpoint with Gateway

 

Without Gateway

API Endpoint without GatewayAPI Endpoint without Gateway

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Hi @hsu,

Unfortunately, Dataflows OData connector does not yet support API Key and Client ID, Secret authentication. Suggest to submit the idea at https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas.

Cheers

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

I don't know about timeframe, but if you want to use API key, you can do that now using other integration methods, such as SSIS. Also Power Automate and Logic apps support using API key via service principal

 

https://powerofpowerplatform.com/using-service-principal-in-power-automate-flow/

Highlighted
Super User II
Super User II

Hi @hsu,

Unfortunately, Dataflows OData connector does not yet support API Key and Client ID, Secret authentication. Suggest to submit the idea at https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas.

Cheers

View solution in original post

Highlighted

Hi!

 

I haven't found any ideas about this. So I've created one here:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Scheduled-Dataflow-with-Custom-Connector-OR-Sta...

 

Or do you already have a nice other workaround? Maybe how to use custom connectors in Dataflows (not Power Automate) ?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Users online (9,513)