Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Processing error: | 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. |
Cluster URI: | WABI-EUROPE-NORTH-B-redirect.analysis.windows.net |
Activity ID: | 151e78e6-176e-4d12-a281-f278e78ff06e |
Request ID: | cc6f6945-43bf-938a-283f-4ef20c798727 |
Time: | 2017-05-29 18:35:46Z |
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
1: xyz.cloudapp.net-DBname
2: Web
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.