Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mohammedkhan
Helper I
Helper I

Data Source Error while configuring Gateway

Hi,

I am new to power bi and came accross that configuring gateway is one of the important task, could you please help me with the mention below error message.

 

This happened when i chosen folder and then given path for the datasource i.e. my excel file 

 

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:7177f6e1-bdd6-4baf-91b8-81b7e174b95c
Request ID:6510183d-d47d-7a52-0dee-67d93dfde764
Cluster URI:https://wabi-us-east-a-primary-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Tue Jun 18 2019 08:24:27 GMT-0400 (Eastern Daylight Time)
Version:13.0.9775.203
Test Gateway:Invalid connection credentials.
Underlying error code:-2147467259
Underlying error message:The credentials provided for the Folder source are invalid. (Source at d:\mk\fas - personal\power bi\power bi - sam mc kay dax.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:Folder
Microsoft.Data.Mashup.CredentialError.DataSourcePath:D:\MK\FAS - Personal\Power BI\Power BI - SAM Mc Kay DAX
Microsoft.Data.Mashup.CredentialError.Reason:AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"Folder","path":"D:\\MK\\FAS - Personal\\Power BI\\Power BI - SAM Mc Kay DAX"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:AccessUnauthorized
2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi @mohammedkhan ,

Does the Gateway and PowerBI desktop on the same machine? Please make sure you enter correct user name and password when adding Excel data source, here is a similar thread, please refer to it: https://community.powerbi.com/t5/Power-Query/Scheduled-refresh-for-excel-file-with-on-premise-gatewa...

Best Regards,

Teige

Yes The Gateway and the Datasource are both in the same System, i am entering the Local System Administrator User Name and Password

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors