Can't set multiple data source credentials - odata.

[bpalermo]

In the last month or so, the scheduled refresh has been giving all sorts of woes - this was working before for 6 months, although it was quite tempremental

I've built some datasets in powerbi desktop, using 2 different odata connections to CRM and Dynamics Marketing, and published to powerbi personal space. 

Previously, I could just go to the data source credentials and put my oAuth details in.  Now I've noticed I set one data source connection and it's actually set both, but the second one is wrong.  No amount of tinkering can get it to work. 

Overnight it will fail with: Can't connect to the data source.

Anybody else having issues with this? 

[cbsalling]

I would like to be able to do the same thing. 

[v-sihou-msft]

@bpalermo

You can expand the "Gateway connection" to see if the Personal - gateway is connected successfully. I think the issue is on the Gateway. Please refer to links below for troubleshooting:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshooting-power-bi-personal-ga...

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-tshoot/

Regards,

[bpalermo]

Thanks for the reply. However, I'm not using a gateway for this, it's a direct connection for both data connections.