Power Query Parameters

[m_smithy]

Hi,

Apologies in advance if this is really simple.

I need help creating a from web query that uses data from another table. That Tables in question is the result of another from web query and so changes when refreshed, with around 1000 lines. 

www.infosource.com/data/&itemID=(A2:A1001) <---- as an example idea of what I am trying to achieve. 

Thanks

[v-shex-msft · Accepted solution]

HI @m_smithy,

If you mean your data is from web form, I don't think you can directly get data from web page.(actually you will get some html elements)

You need to find out api which current page used to generate form. Then use power query web connector to get data form that api with query parameters.

For query parameters, you can refer to following link:

Deep Dive into Query Parameters and Power BI Templates

Regards,
Xiaoxin Sheng