Web.BrowserContents

[Anonymous]

Hi! I retrieve data from a web page using Web.BrowserContents. It works well in Desktop but when I upload it to Report server I get the error below. Do you know what the error is due to? I have anonymous under data source.

The module named 'WebBrowserContents' has been disabled in this context.. The exception was raised by the IDbCommand interface.

 Can I use something else than WebBrowserContents?

Thanks!

[ImkeF]

You can try the Web.Contents function.

[Anonymous]

Hi! I tried but all tables are empty when I use Web.Contents... 

[v-kelly-msft]

Hi @Anonymous ,

Have you granted access for Report server on Web sources?

https://docs.microsoft.com/en-us/sql/reporting-services/security/granting-permissions-on-a-native-mode-report-server?view=sql-server-ver15

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!