While working on Report we suddenly started getting the below error
The strange thing was that the other reports that were using the same data source in the same Report Project were working properly.
Find few posts
but none applied here.
Tried creating a new data source, entered credentials repeatedly but nothing worked, eventually restarted the SQL Server Data Tools (IDE) and it fixed the issue.
Hope it helps..