Dataflow Credentials - ODATA to Sharepoint PWA

[danderson2692]

Hello,

I'm having issues getting an ODATA feed to a PWA Sharepoint Online site to work in a Dataflow. This works without an issue in my desktop app (using the Project Online content pack as a starting point), however when I create the OData connection in the dataflow and enter my credentials, they are not saved and I see the "Please specify how to connect" message. I've created a dataflow to read the Sharepoint Online lists from the same sharepoint site to be sure there isn't anything wrong with its configuration. That Lists connection works without an issue.

Any recommendations? I've tried this on Chrome, IE, Edge, and Firefox.

Thanks,
David

[v-yuta-msft]

@danderson2692 ,

In dataset pane, you can configure the sharepoint credentials, you can then select the authentication ways of your connection:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danderson2692]

@v-yuta-msft I'm not able to set the credentials through that interface until after the dataflow has been created. The dataflow can't be saved until the credentials are initially set in the query because it checks to see if the data loads without errors when you click "save and close".