Forum Discussion

PraveenVeerabh's avatar
PraveenVeerabh
New Member
4 years ago

dynamic data source power bi Web.BrowserContents

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_...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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.