I have a workbook, where some data comes from a SQL server running in VM in Azure (ex. xyz.cloudapp.net).
If i publish the workbook to PowerBI.com and add the Data Gateway everything works fine - refresh can be scheduled.
If i then add a datasource more -> WEB -> pointing to Excel stored in Onedrive in O365 (have also tried saving to Sharepoint Online) and i publish the workbook, i'm no longer able to Schedule Refresh. It states that
You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.
Last refresh failed: Mon May 29 2017 20:35:46 GMT+0200 (W. Europe Daylight Time) Your data gateway (Power BI – personal) is offline or couldn't be reached.Hide details
Your data gateway (Power BI – personal) is offline or could not be reached. Ensure the gateway computer is on and you are logged on to it during the scheduled refresh period.
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Your data source can't be queried because the credentials are not provided. Please provide your credentials and try again.
Under credentials i have two sources where i can type credentials
For the web i can type credentials and everything seems fine, but for the SQL datasource i can retype the SQL credentials, but it just hangs - no error. The same SQL datasource, whice just earlier was working fine through the enterprise gateway