Forum Discussion
b5lurker
7 years agoAdvocate II
Dataset Refresh error for on-prem SSAS and Azure AS Import Combination
Not sure what exactly is causing this particular error, as I have verified that the Gateway is able to connect to our on-prem SSAS server and the user name/password combo is correct and works fine fo...
- 7 years ago
Hi b5lurker ,
From your error information, I suggest you check with your AS credential and password is same with your power BI account.
You could refer to below link about map user names if it could help you:
https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#map-user-names
Regards,
Daniel He
b5lurker
7 years agoAdvocate II
Here is the text copy of the error in case it makes it easier to copy and paste. :)
Last refresh failed: Wed May 22 2019 13:56:06 GMT-0600 (Mountain Daylight Time)
Unable to connect to the data source undefined.Hide details
| Underlying error code: | -2147467259 Table: Mar19 Funnel. |
| Underlying error message: | AnalysisServices: The following system error occurred: The user name or password is incorrect. |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.ValueError.DataSourceKind: | AnalysisServices |
| Microsoft.Data.Mashup.ValueError.DataSourcePath: | bcpsunassql01;Prism_Analytics |
| Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
| Cluster URI: | WABI-WEST-US-redirect.analysis.windows.net |
| Activity ID: | 150c6df6-029e-4957-8467-93a368132ac5 |
| Request ID: | 1071ca48-7388-2b7c-d6e4-8eb4c82f4546 |
| Time: | 2019-05-22 19:56:06Z |