Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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 🙂
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 🙂
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 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 🙂
Thanks so much. The enterprise gateway did the trick.