Scheduled update failed with web data in anonymous mode

[afonsofeliciano]

Hello. 

I have a problem updating a data source on a scheduled basis. 

The error is as follows: 

We're sorry, an error occurred during evaluation.;The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified. The exception was raised by the IDbCommand interface.

And the data source is this: http://fundamentus.com.br/resultado.php

I emphasize that I'm using the latest version of power bi and I tested all connection modes whether anonymous, private, none, public, ignoring connection, etc.

The desktop updates normally, but when scheduling in the service this error always appears.

[nandukrishnavs]

@afonsofeliciano 

You have to use the gateway to set up the scheduled refresh.

Reference link: https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios#refresh-using-we...

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[afonsofeliciano]

@nandukrishnavs can you give me more details? because when you configure the gateway this message appears: you do not need a gateway for this deducted set because all data sources are in the cloud.

[nandukrishnavs]

@afonsofeliciano 

Go to manage gateway --> Add data source --> select Web --> provide your web URL and choose anonymous authentication.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂 

[nandukrishnavs]

@afonsofeliciano 

It is working for me.

[nandukrishnavs]

@afonsofeliciano  is this resolved?