We query the Archer report through the API.
$devices | ForEach-Object{
$ISI_UAT = $_ | select-object -expand "0-ISI - UAT"
INSERT INTO [dbo]
,[ISI_Prod]
VALUES
,'$ISI_Prod'
This is what it looks like in Archer
Here is what it looks like in PowerBI just one big string
The problem at the moment is that the data we’re getting from Archer doesn’t include a delimiter that we can separate the values by. Would it be feasible to add something like a semicolon at the end of each ISI in the Archer Table?
So we want the response something like VMWare; Server Data; IOT Data Driver Decision Portal. Is that possible?
