Impossible to refresh data for a specific query on PBI Service and Desktop

[Anonymous]

Hi,

I loaded data using a custom connector on Power BI Desktop.

I made a request for a specific dataset. 

I made a dashboard on Power BI Desktop using it. 

I uploaded it on Power BI Service (and parametered a gateway) and it worked fine at first, but now when I try to refresh it on Power BI Service, I get the following error message (I made the data anonymous so myurl.com for instance, is actually a working url. 

I noticed that now I have an internal server error (500) when I try to refresh on PBI Desktop as well. What is strange is, if I modify the dates on my query, then I get the data.

The error on PBI Service seems related to the gateway but this gateway works fine for other datasets using the same connector (the only difference is the query, I call a different id). 

Do you have any idea on what I can do ? Thanks in advance. 

Erreur de source de données: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<pi>Web.Contents failed to get contents from 'https://my.url.com' (500): Internal Server Error</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Connector"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"{\"url\":\"https:\\/\\/url.com\",\"client_id\":\"stringofcharacters\",\"client_secret\":\"-stringofcharacters\",\"user_agent\":\"stringofcharacters\"}"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"url.com"}}],"exceptionCulprit":1}}} Table: NameofTable.
URI du cluster: WABI-FRANCE-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
ID d'activité: f0b02f42-6962-4cd5-8d6e-a72f9f73e146
ID de demande: 5afc1911-3c43-5ad3-12d1-d85ca30ddcc8
Heure: 2022-09-14 07:00:39Z

[edhans]

---

@Anonymous wrote:

I noticed that now I have an internal server error (500) when I try to refresh on PBI Desktop as well. What is strange is, if I modify the dates on my query, then I get the data.

The error on PBI Service seems related to the gateway but this gateway works fine for other datasets using the same connector (the only difference is the query, I call a different id). 

---

Both of the above suggest to me this is not the service, nor the desktop, nor likely  the connector itself, but the URL. Changing the dates means the URL is handling it differently when it passes it to the source, and something wrong with those dates (out of range, improperly formatted in the data source???) so it returns a 500 server error.

You should work with both the custom connector maker and the website hosting the URL to troubleshoot, then come back here if everything is fixed on the desktop side and the service still throws an error.