Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

'Unable to connect to data source undefined'

Trying to refresh a dataset from 3 different sources - two are databases within the same server and then one additional server. All have been set up with the gateway I'm using.   I haven't seen the...
Need Help
nickelous's avatar
nickelous
Frequent Visitor
7 years ago

I am getting this on one of my reports this morning as well. But the rest of them were successful.

 

I did update my BI and this newer report was created in the new version. 

 

Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259 Table: DATA.
Underlying error message: Microsoft SQL: The server principal "XXXXXXX is not able to access the database "XXXXXX" under the current security context.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Class: 14
Microsoft.Data.Mashup.ValueError.DataSourceKind: SQL
Microsoft.Data.Mashup.ValueError.DataSourcePath: XXXXXXX.net;XXXXXXX
Microsoft.Data.Mashup.ValueError.Message: The server principal "XXXXXXX" is not able to access the database "XXXXXX" under the current security context.
Microsoft.Data.Mashup.ValueError.Number: 916
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 36b4f496-bcf9-4310-ae37-5bd5ca055ac6
Request ID: 538b9b60-164c-3ac3-d192-812cdeae84c5
Time: 2019-01-25 15:36:08Z