OData Feed: Data Source Connection Error

[V3GAS]

We are having an issue with Data Source connections using an Enterprise Data Gateway on a local server connecting to a Project Server 2013 API. Just a brief FYI - this data source was already connected to /_api/ProjectData and we already have three reports/datasets configured and published, but is now no longer working. 

Our Data Gateway is connected with additional data source connections working properly. We have tried to delete/add the data source back to the gateway, but we are receiving the following error:

When opening the prior reports, we are getting this error in the Query Editor:

Because of the Data Source connection error, the Data Gateway does not show online in the datasets:

Please help... 

[V3GAS · Accepted solution]

Update: After looking into this issue further and speaking with my team, we found that it was our Global Policy removing the credentials to the NT Service\PBIEgwService account that Power BI uses to connect to the Data Gateway. Once we added the account into the Global Policy, the issue corrected itself.

Thank you for taking the time to reply to my concern.

[v-haibl-msft]

@V3GAS

You need to provide the .saz file which you can save with Fiddler.

Best Regards,

Herbert

[v-haibl-msft]

@V3GAS

Could you please repro the problem in Mar 2017 version of PBI Desktop with Fiddler running, clicking "Refresh" in the Query Editor to get the data source error. Then provide the fiddler trace to me?

Best Regards,

Herbert