Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Hi @v-shex-msft
I can´t so much on how to build that type of batch requests.
Could you help me get started?
Thanks in advance
//Gajoll
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |