Forum Discussion
Get data in custom column with a variable link
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
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
Anonymous,
let Bron = Json.Document(Web.Contents("http://1m2m.eu/services/GETPAYLOAD?Human=0&PL=0200058209273a7dd786000000000000")) in BronDo you mean like this?
Thank you for responding.
Anonymous,
"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-Q..."Following this was the solution, thank you!
