Forum Discussion

asifrasool's avatar
asifrasool
Icon for Helper I rankHelper I
3 years ago

johncolley 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=1

second call for

drug?catalogShort=MMI&pzn=2

third call for

drug?catalogShort=MMI&pzn=3

and so on untill last PZN.

 

johncolley's avatar
johncolley
Icon for Solution Sage rankSolution Sage
3 years ago

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

 

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/ 

 

My knowledge in this area is fairly limited so hopefully these help!