Data Source Credential Error when scheduling refresh

Hi All,

I am facing similar issue while deploying cube as dataset from vs to pbi site. I'm using windows authenctication and my datasource is sqlserver 2017. I have like 10 datasets to be deployed out of which 8 are success, but remaining 2 seem to throw "Refresh can't be scheduled because the data set doesn't contain any data model connections, or is a worksheet or linked table. To schedule refresh, the data must be loaded into the data model."   I have tried updating permission settings, updating processing type of the datasets but still no luck. If I deploy 4 datasets on one day, I can't deploy the rest of them on the same day. However, If i try the following day, it works. I have tried restarting my servers but that too doesn't do the trick. My datasets deployments that point to QA servers seem to work, but ones on staging servers give me above mentioned error. I have compared permissions and settings of QA and Staging and they are exactly the same. 

Any help would be appreciated!!

Thank you

@refresh