dynamic data source power bi Web.BrowserContents

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

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-bi/ 

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/ 

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.

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

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.