Forum Discussion
'Unable to connect to data source undefined'
Can anybody help to resolve the issue in PBI Service? The issue has been reported in many places of Internet, but never got fixed. Thanks.
My data source is only from OData API, using Import mode. Refreshing succeeded in PBI Desktop but failed in PBI Service, so I consider the issue is at gateway or PBI service self. Thus, I reinstalled both standard and personal modes of gateway, reinput the credentials, and even republished the pbix file on PBI Service ... does not work yet.
The tables are different, but error message and error code are always same.
Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259 Table: DocumentToProtocolRelationships.
Underlying error message: OData: Request failed: Unable to connect to the remote server
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: 84726276-12ae-46cb-b636-b1a81fe4c0fe
Request ID: 436e8798-ef78-40fb-b5c2-24fafc412259
Time: 2019-10-02 00:17:05Z
Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259 Table: Implementations.
Underlying error message: OData: Request failed: Unable to connect to the remote server
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: 3e3e62d0-d5af-4022-a19f-828ad65d7078
Request ID: 74c1a014-4cd6-4c10-831f-c53f485cf78a
Time: 2019-10-01 16:19:10Z
My reports have been working well on PBI Service for long time, but now cannot refresh successfully with the following error message always:
Last refresh failed: Tue Oct 08 2019 14:32:21 GMT-0700 (Pacific Daylight Time)
Unable to connect to the data source undefined.Hide detailsUnderlying error code:
-2147467259 Table: Products.
Underlying error message:
OData: Request failed: Unable to connect to the remote server
DM_ErrorDetailNameCode_UnderlyingHResult:
-2147467259
Microsoft.Data.Mashup.ValueError.Reason:
DataSource.Error
Cluster URI:
DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:
6029d4c4-55f3-4928-b640-229166fe5d14
Request ID:
e2edc094-9a1a-6907-4632-e8d4d5ff3330
Time:
2019-10-08 21:32:21Z
Last refresh failed: Tue Oct 08 2019 15:15:18 GMT-0700 (Pacific Daylight Time)
Unable to connect to the data source undefined.Hide detailsUnderlying error code:
-2147467259 Table: ProtocolToChildProtocolRelationships.
Underlying error message:
OData: Request failed: Unable to connect to the remote server
DM_ErrorDetailNameCode_UnderlyingHResult:
-2147467259
Microsoft.Data.Mashup.ValueError.Reason:
DataSource.Error
Cluster URI:
DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:
6029d4c4-55f3-4928-b640-229166fe5d14
Request ID:
c3350f39-ee6a-6bf5-665b-4cd1b3f5fdeb
Time:
2019-10-08 22:15:18Z
It is able to refresh successfully from PBI Desktop, but cannot refresh from PBI Service. Even though refreshed the same dataset multiple times, I got the same error code(-2147467259) on different tables above. The error "Unable to connect to the remote server ( error code: -2147467259)" was prompted multiple times in lots of articles from Internet, inculding the PBI community, but looks never be resolved?
Certainly, I doubt some issue in Gateway, and verified the Gateway network connection successafully. However, I cannot find any *.zip log file under relevant folders at all after clicking the 'Export Logs' link from the App UI (I submitted another post for this problem).