Multiple API Calls for Template Content Pack

[Sean-Hone]

Hi,

I am trying to make a template content pack that will eventually be submitted to be a service.

The data I want to use comes from several different api calls e.g:

mypretendapi/company/user.json

mypretendapi/companyclient.json

mypretendapi/pay.json

etc...

I understand one of the restrictions is to only have a single end point so I am wondering what is the best practice way to get around this problem.

I would like to stay away from a single api call that returns all of these tables.

I have also tried making a custom function which changes the end of the url e.g "/company/user.json" and returns the related tables. Although the table is not listed as it's own data source after the call I fear it would still not fit the requirements for publishing a template content pack.

What solution would you recommend.

Thanks for your time.

[Anonymous · Accepted solution]

Hi @Sean-Hone,

Unfortunately, power bi not support invoke multiple api at once, you need to use multiple web connector to invoke each api.

In my opinion, you can try to modify your api strings to two part: API header and detail.

Header means same part of your api, detail means different part and concatenate with delimiter, then use some nested m query functions to analyse them as source table.

Sample:

Parameter Header: "mypretendapi/"
Parameter Detail: "company/user.json;companyclient.json;mypretendapi/pay.json"

Notice: Power query not support direct use one query to generate multiple query tables, it also not support dynamic table structure.

Regards,

Xiaoxin Sheng