Lack of Gateway preventing scheduled refresh

[Gazzer]

I have a report which has been uploaded and was refreshing daily with no problem.

I added a new query which was from an Excel file stored on a local network. I realised this was not going to work for the daily refresh as I would need the gateway installed and did not want to do that, so I copied and pasted the content of the Excel file (a simple list of UK bank holidays) and deleted the Excel query.

Now when I upload this it fails to refresh and is telling me to install a gateway.

All of the queries are web queries and all were refreshing on a schedule until added and removed the query to the local file.

[v-ljerr-msft]

Hi @Gazzer,

According to your description above, I have tested it on my environment, but I was not able to reproduce the same issue. I created a report with just web sources(the refresh work fine without a gateway), then add a local excel file to the dataset(the refresh failed because a gateway is needed). However, after I removed the local excel file, and paste the content with Enter Data, the refresh works again without any error.

Could you try deleting the whole dataset from Power BI service first, then republish it from Power BI Desktop to see if it works?

In addition, make sure you've removed all related queries from the local file, and also make sure you're using the latest version of Power BI Desktop. 

Regards

[Gazzer · Accepted solution]

Thanks for the advice. I think we may have just found the issue which may be a web connection to xe.com, which works fine in Desktop but not when the online service tries to refresh.

I have posted a question relating to that elsewhere, so please consider this issue resolved.

[v-ljerr-msft]

Hi @Gazzer,

So could you accept your reply above to close this thread? 

Regards