On-Prem Gate way

[abehrmann]

i migrated my on prem gateway but i am having an issue connecting nowl, I am recieveing the below message

nable to connect: We encountered an error while trying to connect to . Details: ""Hide details

Activity ID:	9d9c987f-271e-340b-b93f-871bdaadac11
Request ID:	ccab14cb-1521-dccb-961a-69b3fbd7e84c
Cluster URI:	https://wabi-us-north-central-b-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_UpdateClusterDatasourceCredentialsErrorCode
Time:	Tue Aug 21 2018 12:52:40 GMT-0400 (Eastern Daylight Time)
Version:	13.0.6358.131

Data_Refresh:	Cannot connect to the mashup data source. See error details for more information.
Underlying error code:	-2147467259
Underlying error message:	Could not find a part of the path 'C:\Users\Alex Behrmann\OneDrive - CS Hudson\PowerBI\DataRefresh\Client_Invioce.xlsx'.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error

[GilbertQ · Accepted solution]

Hi there,

Based on the error the files were stored on the C: Drive of the previous server. And now that you migrated servers it is on a different server that does not have the files.

Ensure that the XLSX files are stored in the identical location. 'C:\Users\Alex Behrmann\OneDrive - CS Hudson\PowerBI\DataRefresh\Client_Invioce.xlsx'.

[v-frfei-msft · Accepted solution]

Hi @abehrmann,

As the error message, that you did not add the data souce to the gateway. Could you please select the gear icon and manage gateway to add data souce in Power BI service, and try again? For more details, please check the online document. 

Regards,
Frank

[GilbertQ · Accepted solution]

Hi there,

Based on the error the files were stored on the C: Drive of the previous server. And now that you migrated servers it is on a different server that does not have the files.

Ensure that the XLSX files are stored in the identical location. 'C:\Users\Alex Behrmann\OneDrive - CS Hudson\PowerBI\DataRefresh\Client_Invioce.xlsx'.