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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors