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.
Hi All,
I've installed and configured on-premise data gateway but when I try to adding data source (in this case an Excel file saved on my desktop) I get the below error details:
Activity ID: | 6436b4ab-689e-7514-2ba6-5d86778a445c |
Request ID: | f8dfb7d6-fe6d-a84a-7b64-6e15f044f282 |
Cluster URI: | https://wabi-australia-southeast-redirect.analysis.windows.net |
Status code: | 400 |
Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
Time: | Wed Jun 06 2018 23:45:53 GMT+1000 (AUS Eastern Standard Time) |
Version: | 13.0.5484.164 |
Gateway1: | Invalid connection credentials. |
Underlying error code: | -2147467259 |
Underlying error message: | The credentials provided for the File source are invalid. (Source at c:\users\johnmatta\desktop\book1.xlsx.) |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.CredentialError.DataSourceKind: | File |
Microsoft.Data.Mashup.CredentialError.DataSourcePath: | c:\users\johnmatta\desktop\book1.xlsx |
Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"File","path":"c:\\users\\johnmatta\\desktop\\book1.xlsx"}] |
Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
Solved! Go to Solution.
@Johnmatta,
Do you install gateway in the same machine with your Excel file? Please make sure you enter correct user name and password when adding Excel data source, you can follow the guide in the similar thread below.
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-o...
Regards,
Lydia
@Johnmatta,
Do you install gateway in the same machine with your Excel file? Please make sure you enter correct user name and password when adding Excel data source, you can follow the guide in the similar thread below.
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-o...
Regards,
Lydia
Hi Lydia,
I've found my domain\user and the datat source added successfully but when I tried to refresh the data I got the floowing message:
@Johnmatta,
Please post the data source setting(File->Options and settings->data source setting ) in Power BI Desktop and share a screenshot about the data source you added within your gateway. Please do mask sensitive data before you upload screenshots.
Regards,
Lydia
Hi @Johnmatta ,
I am encountering the same exact issue at the moment, could you please guide me to how you found out the username and what steps you took to make it work?
Big thanks,
Vlad
Hi @vladmoza ,
Please find the below steps:
hope that helps.
John
Hi. @Johnmatta @v-yuezhe-msft . I am facing some problems. When I try to connect i get same credenctial problems:
DMTS_PublishDatasourceToClusterErrorCode
We could not register this data source for any gateway instances within this cluster
Cluster URI: https:wabi-north-central-primary-redirect.analysis.windows.com
Could anyone help?Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.