cancel
Showing results for 
Search instead for 
Did you mean: 

'Unable to connect to data source undefined'

Hi,

 

I'm getting below error since January 29th this year:

Unable to connect to the data source undefined.


Underlying error code: -2147467259
Underlying error message: The key didn't match any rows in the table.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Key: [Name = "macro_audit_log"]
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 986d800f-e697-4738-853b-9a63006337a1
Request ID: 2c821adf-af9d-5baa-4617-dee598e4eda1
Time: 2019-02-08 15:37:40Z


I haven't made any changes to the data source settings, neither to the dataset. I have 3 different datasources in my dataset: Teradata, Oracle & SharePoint. This issue is with Teradata source. However, in PowerBi desktop the entire dataset is getting refreshed fine without any issues. Only in PowerBI service, I'm facing this error. Please help.

Status: New
Comments
Moderator

Hi @Puneeth_Acharya ,

 

From internal trace, I find the "User is not authorized" error. I would suggest you check if the data source in Manage Gateways and credential in Dataset Settings for the dataset are fine. Also please check the Privacy level setting for Teradata and Oracle data source in Manage Gateways section. 

 

Best Regards,
Qiuyun Yu