Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nicodem
Frequent Visitor

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

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

1 REPLY 1
edhans
Super User
Super User


@nicodem 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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.