we started receiving this error. Everything was working fine for about 1 year, no changes in system nothiing. I even changed credentials in report and published it again, autorefresh just doesnt work, connection to Gateway and datasources is showing as its ok... very weird:
Underlying error code-2147467259 Table: B2B.
Underlying error messageThe key didn't match any rows in the table.
Sounds like its the table data with the problem B2B table..."Underlying error messageThe key didn't match any rows in the table."..I dont see its a credential error from the error message you submitted.
Have your checked the columns of your B2B table data in the query editor for errors? I would step through each step of the transformations in your queries to see if its causing an issue. A sample image of the table data would be useful.
Perhaps submit more information about the data source so we can trouble shoot it.