Refresh dataset connect to SQL and shared Power BI Dataset

[ElmerVMN]

I have created a dataset what is connect to SQL and a shared Power BI dataset.  If I refresh this report locally in the Power BI desktop it works fine..  The problem is if I try to refresh the repport in the cloud I am getting a error. 

I configured the Gatewaysettings correctly and have also provide a login to the references.

Do I need to setup something else ?  I am not sure what I have done wrong... or do different ?

[ElmerVMN]

Hello amitchandak,

Thank you for your advise but I have done earier that exactly how you explain.

The login (OAuth2) goes create.. but when trying to refresh in the cloud I am getting the error.

Is it something with the login ?  (Because If I refresh the set in Desktop it works)

Regards

[amitchandak]

@ElmerVMN , On the first file/ dataset, where you configured , go to dataset setting and make sure connection details and  gateway details.

For the second file, login to power bi the connection setting -> Under setting of dataset