Dataset Refresh Doesnt Work When Using Third-parthy Website

[Anonymous]

Hello colleagues!

I want to add CPU Rating from https://www.cpubenchmark.net/CPU_mega_page.html to my report.

I've made source:

let
Source= Web.Page(Web.Contents("https://www.cpubenchmark.net/CPU_mega_page.html")),
Data1 = Source{1}[Data] ...

In Power BI Destop everything is ok. But when I publish it, I got error:

[v-yuta-msft]

@Anonymous ,

As the error message mentioned, you may not have installed and configured data gateway correctly. Please install the latest version of power bi data gateway and check if this issue persists.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

I've solved the error. The solition is to add source to the gateway in PowerBI Service.