dynamic data source power bi Web.BrowserContents

[PraveenVeerabh]

I have extracted the information using the below link. But this link is not working in power bi online.

Source = Web.BrowserContents("https://www.glassdoor.co.in/Salaries/"&sup&"-salary-SRCH_IL.0,5_"&lin&"_IP " & Page & ".htm"),

[Sigma22]

Is there any way possible to extract from below source https://www.ambitionbox.com/reviews/microsoft-corporation-reviews or https://www.ambitionbox.com/salaries/microsoft-corporation-salaries following a chronological order starting with the latest one.

[PraveenVeerabh]

Thank you so much for the details. I have been able to construct the link using relative path and query. However when i changed the source to Web. Contents I am not getting any data. Also if change the source Web.BrowserContents i am getting an error.

Web.BrowserContents(
"https://www.glassdoor.co.in",
[Query="/Salaries/"&sup&"-salary-SRCH_IL.0,5_"&lin&"_IP " & Page & ".htm"]
),

Not getting the data when i enter web.contents

[v-jingzhang]

Hi @PraveenVeerabh 

Dynamic data sources are not supported when you refresh the dataset in Power BI Service. You can convert the Source step into a structure with the RelativePath and Query options with Web.Contents() function. Please refer to the following blogs for more details:

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power... 

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i... 

https://hatfullofdata.blog/power-query-dynamic-data-source-and-web-contents/ 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[otravers]

Web.BrowserContents requires a data gateway to refresh in the service, even if it's a publicly available page. Try using Web.Contents instead.