Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 (a...
Need Help
Tutorial Requests
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
3 years ago
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.