Issue with connecting to Odata in dataflows

[tex628]

Hello, 

I'm having an issue when I attempt to connect to a Odata source in dataflows. 

When i attempt to veryfy credentials through organisational account the prompt does not let me log in, instead saying "Unexpected Error (Session ID: XXXXXXX...)"

When I connect to the same URL in PowerBI desktop i can access the data without issue. 

Does anyone know how to solve this?

Br,
Johannes

[v-qiuyu-msft]

Hi @tex628,

Which data source do you use OData connector to get data from? 

Is the gateway is required? Please update the gateway to the latest version then test again if gateway is used. 

Best Regards,
Qiuyun Yu 

[tex628]

Azure SQL. Gateway is not supposed to be required. 

[v-qiuyu-msft]

Hi @tex628,

Please test again. If the issue persists, please create a support ticket. 

Best Regards,
Qiuyun Yu