The gateway doesn't work !

[moshe_Arama2022]

Hi can you please help me with that error ?

i try to connect to Excel file , i copy the data source and all 

but i'm still cant refresh the that ,

look at the error that i get :

"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the File source are invalid. (Source at u:\\maintenance\\shift_table\\timestamps_summary_update.xlsx.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"File"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"U:\\Maintenance\\Shift_Table\\Timestamps_Summary_Update.xlsx"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"File\",\"path\":\"U:\\\\Maintenance\\\\Shift_Table\\\\Timestamps_Summary_Update.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: Not_Includes PM's.

[moshe_Arama2022]

I read what you sent it doesn't help me

I need to know how to link to an excel file

[Anonymous]

Hi @moshe_Arama2022 ,

Please refer this document: The Power BI Gateway; All You Need to Know - RADACAD

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @moshe_Arama2022 ,

Please use the correct credentials for gateway datasource.

For more details, you can read related document: Add or remove a gateway data source - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[moshe_Arama2022]

what does error code means ? 

lokk at the attached picture 

[Anonymous]

Hi @moshe_Arama2022 ,

Your credentials are invalid for the data source, please use the correct credentials.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[moshe_Arama2022]

Hi , what does it meat that the credentials are invalid ? I put my password that i insert to my computer every morning what i need to put i the AUTHENTICATION fileds ??