Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Scheduled Refresh with Web Source Not Working

Hi all,   I have built a PBI report on PBI Desktop using SQL database and Web as data sources. The Web source is used to call http://useragentstring.com and the report passes user agent values in ...
Refresh
Report Server
scheduled refresh. web source
Matija's avatar
Matija
Frequent Visitor
7 years ago

I have the same issue. I get a message on the dataset in Power BI Service: Query contains unsupported function. Function name: Web.Contents. In Data Sorce settings in Power BI desktop, I see: “Some data sources may not be listed because of hand-authored queries”, even though I changed all data sources to Public as suggested in this blog.

 

Apparently, there is a Skip test connection function added recently which might solve this issue but I cannot find it in Power BI Service (or desktop for that matter).

 

Any thoughts Power people?

 

 

Matija's avatar
Matija
Frequent Visitor
7 years ago

Does anybody have an idea?

 

Maybe there is a better way to fetch data from API, something I can use instead of Web.contents function?