Data Extraction from web content

[manojk_pbi]

Hi,

I have a use case wherein i am extracting data from OData.Feed. This will return me few data fields using which i will have to construct a web link and extract few more data fields. 

In first instance it is working fine and i am connecting using Gateway. For the second part i am getting below error message as the web link is getting created dynamically.

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.

• Data source for Query1

How can we make it work or is it not possible at all ? The same works fine from desktop.

[lbendlin]

You need to try and present a static base URL to the Power BI service.  Show a sanitized version of the Power Query code.

[manojk_pbi]

I am using below line, url is field name from the table having the web link to workitem

url looks like https://tfs.org.com//tfs/ProjectName/Collection/_apis/wit/workitems/256879

Table.AddColumn(#"Added Custom", "VSTS", each Json.Document(Web.Contents([url])))

[lbendlin]

The workitem ID needs to go into the RelativePath parameter. 

Web.Contents - PowerQuery M | Microsoft Learn

[manojk_pbi]

I didn't get you, pls could you elaborate. Is not possible to pass dynamic query or is there any work around solution for it 

[manojk_pbi]

Hi @lbendlin , looking for your suggestion