Forum Discussion

OmarTalk2IoT's avatar
OmarTalk2IoT
Frequent Visitor
7 years ago
Solved

Get data in custom column with a variable link

Hello,   I am currently trying to have a variable URL with data. An example of a link where my data will be retrieved from is:  http://1m2m.eu/services/GETPAYLOAD?Human=0&PL=0200058209273a7dd7860...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

OmarTalk2IoT,

Could you please post he M code when you directly get data from http://1m2m.eu/services/GETPAYLOAD?Human=0&PL=0200058209273a7dd786000000000000?

In Power BI Desktop, you can create a function by creating a PL parameter based on the above code, then invoke the function in the payloads table. There is a similar blog for your reference.

http://blogs.adatis.co.uk/callumgreen/post/Loop-Through-Webpages-with-Multiple-Parameters-in-Power-Query

Regards,
Lydia

OmarTalk2IoT's avatar
OmarTalk2IoT
Frequent Visitor
7 years ago

Anonymous,

 

let
    Bron = Json.Document(Web.Contents("http://1m2m.eu/services/GETPAYLOAD?Human=0&PL=0200058209273a7dd786000000000000"))
in
    Bron

Do you mean like this?

 

Thank you for responding.