Power BI not refreshing web data sources

[Gerhardvdw]

Hi

I have about 5 web data sources in a Power BI report.  All anonomous access.  The Power BI service cannot refresh these data sources and I get the error below:

Something went wrong
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 error: 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.
Cluster URI: WABI-SOUTH-AFRICA-NORTH-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 67b74966-33e1-4ef6-90d8-7a590292e1dd
Request ID: c7297f75-d27f-462c-9570-f18b6ffa9c88
Time: 2020-05-07 03:20:33Z

The data sources refresh in Power BI desktop.  

Anyone got an idea on where to look to resolve this?

Thanks

[nandukrishnavs]

@Gerhardvdw 

Use the Power BI gateway and add the web source.

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

[Gerhardvdw]

Hi 

Thanks for the response, but the Power BI service is not allowing me to use the gateway (Personal) 

I see the following on the gateway settings in the Service.

[Gerhardvdw]

[nandukrishnavs · Accepted solution]

@Gerhardvdw  You can try with enterprise gateway. Go to manage gateways, then add a new data-source. It should work.

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

[Gerhardvdw]

Thanks so much.  The enterprise gateway did the trick.

[nandukrishnavs]