Forum Discussion

V3GAS's avatar
V3GAS
Helper I
9 years ago
Solved

OData Feed: Data Source Connection Error

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... 

Gateways
  • V3GAS's avatar
    V3GAS
    9 years ago

    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.

     

4 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    V3GAS

     

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

     

    Best Regards,

    Herbert

  • V3GAS's avatar
    V3GAS
    Helper I
    9 years ago

    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.