Multiple dataconnections once

Hi,

I´m about to build a report based on an API which returns XML-reports.

I have one Report string (Https) to collect every customer and the number of servers/Workstations and ClienID and so on.

This have a https string which look like: 

https:// wwwxxxxxx.xxxxxxxxxxxxx.com/api/?apikey=xxxxxxxxxxxxxxx&service=list_client_license_count&clientid=234567

That one is not an issue since it´s only one string.

But in the same report I want to display information regarding every customer in another tab, those string has the followin syntax(at least two strings for every customer):

For information regarding Clients:

https:// wwwxxxxxxxxxxx.xxxxxxxxxxxxxxx.com/api/?apikey=xxxxxxxxxxxxxxxxxxxxx&service=list_devices_at_client&clientid=1232123&devicetype=workstation

Fo information regarding servers:

https:// wwwxxxxxxxxxxx.xxxxxxxxxxxxxxx.com/api/?apikey=xxxxxxxxxxxxxxxxxxxxx&service=list_devices_at_client&clientid=1232123&devicetype=server

I except it could be around 3-400 connections to get information for ever customer.

I also want to auto-save the information every 1st in the month to compare new data with te month before.

How can I do this in a smart way? As it is now I´ve tested to add the connections manually but it takes a very long time and Power BI get slower and slower when I´m adding the connections.

Thanks in advanced and hope someone can answer :)!

//Gajoll