cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft Employee

Re: CDS OData integration. Invalid credentials

The fix for invalid OData Basic/Windows connections should be fixed. Please let us know if you encounter more issues.

Thanks.

Thanks,
Alejandro
romber
Level: Powered On

Re: CDS OData integration. Invalid credentials

Hi @alopezlago ,

 

now when I try to create a data integration project for OData I'm not able to select Basic Authentication. Only two option I have got there are "Anonymous" and "Organizational Account". So basicaly I'm still not able to connect to OData through Basic Authentification. Could you please explain to me what I'm doing wrong. Thank you.

 

PowerApps_OData_integration.PNG

agemlex
Level: Powered On

Re: CDS OData integration. Invalid credentials

I can't connect to Basic through on premise gateway with same error 500. Where am I wrong?

test-connection.png

Microsoft Employee

Re: CDS OData integration. Invalid credentials

@romber Basic authentication for Web and OData is only supported when using an on-premise data gateway due to technical limitations with the connection in PowerApps. 

 

@agemlex This error looks unrelated to credentials not working with OData. When does this error occur? Could you give us the session ID when this happens (which can be access from the Options dialog, accessible from the ribbon)?

 

Thanks.

Thanks,
Alejandro
romber
Level: Powered On

Re: CDS OData integration. Invalid credentials

Hi @alopezlago 

 

thanks for the info. But could you also explain me at least roughly why do I need on-premise data gateway? When I'm trying to consume this OData feed in PowerBi I don't need any on-premise data gateway.


Will be there in a future option to authenticate through the Basic authentification?

 

Thanks,

Roman

agemlex
Level: Powered On

Re: CDS OData integration. Invalid credentials

I don't know, where can I get a session ID? This error accure when I push to test my custom connector.

Maybe we are will make Skype call? Or I can do for you l2tp connection to our test system? My GMT+6 work time from 8-30 till 17-40. Or give me an instruction for get session ID.

Microsoft Employee

Re: CDS OData integration. Invalid credentials

@romber This is a technical limitation with the Connections in PowerApps. A connection can only support one authentication kind when used without a gateway. There's a trick we use to support both Anonymous and Organizational/Microsoft accounts, but that trick doesn't work for Basic. Power BI uses a different connection model which doesn't have this limitation.

 

I'm not aware of any plans to support Basic outside of the on-premise data gateway at this time. Sorry. 

Thanks,
Alejandro
Microsoft Employee

Re: CDS OData integration. Invalid credentials

@agemlex In which screen did the error occur? It looks like you were able to successfully load the data from OData into CDS. My expertise is only in that (data integration) area, so if the error is occurring on another component I won't be of much help, but I can help track down somebody who is more familiar with the area (where the error is now occurring).

 

Thanks.

 

Thanks,
Alejandro
Microsoft Employee

Re: CDS OData integration. Invalid credentials

@agemlex Is there a "product" field in your data that is ever null or empty? That is the likely cause of your error message.

Thanks.

 

Thanks,
Alejandro
agemlex
Level: Powered On

Re: CDS OData integration. Invalid credentials

@alopezlago, thank you for your replies!

 

In attachment screenshots. This is what I do&see.