Hi @Bushra_BV
Looking at the dataset definition this is a Direct Query dataset. Since you are able to get into the dataset it appears to me that the issue is your permission to the underlying table/view in the database.
Have you checked if you can run the query in the source database?
Regards,
Giri