Forum Discussion
No content with Web.Contents vs. Web.BrowserContents
Hi v-yingjl ,
thanks a lot for your reply.
But maybe I have not been very clear in my post: I am still in both scenarios within Power BI Desktop.
Only to avoid later-on issues when publishing to service I want now to switch from Web.BrowserContents to Web.Contents - why (small excurseion:
When using Web.BrowserContent - I receive in the PBI Service the following error message:
" This dataset includes a dynamic data source." with a link to https://aka.ms/dynamic-data-sources
There is said:
In most cases, Power BI datasets that use dynamic data sources cannot be refreshed in the Power BI service. There are a few exceptions in which dynamic data sources can be refreshed in the Power BI service, such as when using the RelativePath and Query options with the Web.Contents M function.
As I understand it I have to use Web.Contents with "RelativePath" instead of Web.BrowserContents. And this way it works also for other projects scraping other web-shops perfectly fine for me later-on in PBI Service (without On Premis Gateway).
But for the specific URL mentioned above I receive different results from Web.Contents compared to Web.BrowserContents.
So my main question is: How to workaround to receive the same HTML result from Web.Contents within PBI Desktop (in order to be able to publish it later-on to PBI service)?
Hi,
It seems that the accepted solution doesn't really help to find a workaround.
I also need to download HTM table (so I use the Web.BrowserContents function) but I can not refresh it on Power BI Service.
Did you find a workaround to be able to use the web.Contents function with an HTML table ?
Anonymous - I'm also trying to figure out this issue. Usually replacing Web.BrowserContents with Web.Contents would work but it seems in some cases (maybe website design/formatting) it just results in no values.
I also suspect that the "answer" here was not marked as the solution by the OP.
Anonymous- did you find a workaround or cause for this? I'm guessing you didn't mark the accepted answer as the solution?
Dear KNP & Anonymous,
if I remember correctly the issue was that the respective HTML-Product-Detail-Page (PDP) was built "on the fly" by a JAVA function getting the data from a data-base... while Web.BrowserContent obviously got the already "produced" PDP, Web.Content somehow failed.
Thus the workaround was not to scrape the PDP, but instead the URL called by the JAVA function to get the JSON data from the master-data server and afterwards converting this JSON into a table. An even significantly faster and more reliable way 😊
However, if you find some news on this topic above I would be glad to see the solution here - thanks a lot!
Best
FloriGiChanging "Web.BrowserContents" to "Web.Contents" in the source was the solution for me. No need for a local gateway. Thank you very much.
