Unable to refresh the data from Web URL in power bi published report.

[Anonymous]

Hello Guys, 

I am getting the above error while refreshing my dataset in power bi service. My report is not fatching data from the web URL.

Everything looks good in Power bi desktop but data is not updating in published dashboard. 

Can anyone help me on this. 

regards
sandeep singh 

Here is the details of the error: 

Error msg:
There was an error when processing the data in the dataset.Please try again later or contact support. If you contact support, please provide these details.

• Data source errorWe'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. Table: Corona Virus.
• Cluster URIWABI-US-EAST2-redirect.analysis.windows.net
• Activity IDf15987d0-a7e2-45b2-b508-af092c697480
• Request ID82a4f25e-2b5c-3050-0171-8877f74f5b5a

Time2020-03-13 10:44:16Z

[christianjohan]

I have the same problem. Data source: https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population

[jpierzchala · Accepted solution]

I have managed to solve the issue on my end. 

Just as I suspected, the newly released May update contained the change introduced earlier into the engine, that the service uses and it stopped refreshing the desktop as well.

On my end it was "reached end of the buffer" problem. I believe they have silently introduced a limit on how much data the Web.Contents function can receive. 

I've solved this by decreasing page size when obtaining data from Web API

[jpierzchala]

I am getting the same error with a report that used to refresh without problems. No changes and then suddenly this. My guess would be something changed in the service engine as PowerBI desktop refreshes the report without problems

[v-shex-msft]

HI @Anonymous,

Can you please share some detail information to help us clarify your scenario? It will be helpful for troubleshooting.

For example:

Data source type, connection mode and credentials configuration, advanced operation in query steps...

How to Get Your Question Answered Quickly  
Regards,

Xiaoxin Sheng

[Greg_Deckler]

I could be mistaken, but I'm fairly sure that the issue is that "The system cannot find the file specified", 🙂

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".