Multiple dataconnections once

[Gajoll]

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

[Anonymous · Accepted solution]

Hi @Gajoll ,

I haven't found effective methods to handle such many connections, I'd like to suggest you to do these operations before get data to power bi.

For example: write API/web service to send batch httprequests and merge received data to local file, then you can use power bi to get data from result file and create visualizations and report.

Regards,
Xiaoxin Sheng

[Gajoll]

Hi @Anonymous 

I can´t so much on how to build that type of batch requests.

Could you help me get started?

Thanks in advance

//Gajoll