Unable to refresh/schedule refresh WEB API call on Power BI service.

Question

We have created one power BI desktop file which use/call WEB API through power query (Web.Content()method ) to call/import data.
When we refresh this power BI desktop file to fetch the data from the web api it works fine.

When we published this power BI desktop file to power bi cloud service and refresh/schedule refresh the Dataset (which get data from web api call) it given below mentioned error.

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Status code:   400
Error Code:   DMTS_PublishDatasourceToClusterErrorCode
Time:   Fri Aug 31 2018 12:08:25 GMT+0530 (India Standard Time)
Version:   13.0.6517.123
VM-Fleet-Gateway:   Invalid connection credentials.
Underlying error code:   -2147467259
Underlying error message:   The credentials provided for the Web source are invalid. (Source at https://testurl/Customers.)
DM_ErrorDetailNameCode_UnderlyingHResult:   -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:   Web
Microsoft.Data.Mashup.CredentialError.DataSourcePath:   https://testurl/Customers
Microsoft.Data.Mashup.CredentialError.Reason:   AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:   [{"kind":"Web","path":"https://testurl/Customers"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:   AccessUnauthorized
Troubleshoot connection problems

Thanks

dheeraj_pareek · Answer

Hi Jimmy,Thanks for adding the link.I have gone through this link and checked the work around mentioned to pass parameters in the web URL.I am facing 2 main problem, which is as follows:1. We need to pass the "authentication token" inside the header of web url to get the information from REST API.Do we need to configure this "authentication token" in power bi service as well?I did not find any configuration area on power bi service for this.2. when we configure some web link in data gateway it gives below mentioned error.Error details: "Failed to update data source credentials: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel"We have alredy configured the self siged certificate on the development machine on which we are using the power bi desktop and service.Is the above mentioned error is due to ssl certificate?Can you please provide some help on these issues?Thanks

v-yuta-msft · Answer

Hi dheeraj_pareek,
&nbsp;
There's some limitation with Web.Content(), as a workaround, please refer to this documentation.
&nbsp;
Regards,
Jimmy Tao

dheeraj_pareek · Answer

Hi Jimmy,&nbsp;Thanks for update.&nbsp;Please provide link for reference document.&nbsp;Thanks

v-yuta-msft · Answer

Hi&nbsp;dheeraj_pareek,
&nbsp;
Sorry, you can refer to this blog: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/.
&nbsp;
Regards,
Jimmy Tao

v-yuta-msft · Answer

Hi dheeraj_pareek,
&nbsp;
Please click dataset-&gt;settings-&gt;datasets-&gt;data source credentials to check if the credential option exists. Also please check if your browser supports&nbsp;SSL/TLS secure channel or not.&nbsp;
&nbsp;
Regards,
Jimmy Tao

Forum Discussion

Unable to refresh/schedule refresh WEB API call on Power BI service.

7 Replies

Related content

Schedule refresh

Power BI Service Scheduled Refresh

Schedule refresh

Refresh/ Scheduled Refresh sudddenly disabled

Power Bi Service - Schedule Refresh