Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 |
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
88 | |
46 | |
25 | |
21 | |
19 |