Forum Discussion
Helper IDynamically changing url to get the data based on relevant parameter
Solution SageHi asifrasool ,
You can create a new column using Concatenate to create a url string. I.e
URL = Concatenate("e.g. drug?catalogShort=MMI&pzn=",'PZN Column')
This will generate a url for each PZN number in your table.
If this answer solves your problem please mark it as a solution!
asifrasooljohncolley Thank you so much for the response,
Actually the thing is that I have to make rest api calls, with first call I'll get the list of PZN numbers. Then I have to make api calls related to each PZN number. like this,first call for
drug?catalogShort=MMI&pzn=1second call for
drug?catalogShort=MMI&pzn=2third call for
drug?catalogShort=MMI&pzn=3and so on untill last PZN.
- johncolley
Hi asifrasool , Once you get your list of numbers you may be able to parameterise it for the rest of the calls, more detail here: https://www.phdata.io/blog/how-to-parameterize-data-sources-power-bi/
There also may be some useful information in these threads:
https://community.powerbi.com/t5/Desktop/RestApi-with-Session-Authentication/td-p/624578
My knowledge in this area is fairly limited so hopefully these help!