Connect-PowerBIServiceAccount | ConvertFrom-Json $refreshSchedule

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Connect-PowerBIServiceAccount $user = whoami $user = $user.Split("\")[1] $now = Get-Date $file_path = "C:\Users\{0}\OneDrive - Management Controls, Inc\Desktop\powerbi-api-dataset-info-{1}-{2}_{3}{4}{5}.csv" -F $user, $now.Month, $now.Day, $now.Hour, $now.Minute, $now.Second "DatasetID, LastRefreshdt, Result, days, times" | Out-File -FilePath $file_path -Append -Encoding ASCII $InputURL = '/admin/capacities/refreshables?$top=5000&' + '&$expand=group' $ParsedResponse = Invoke-PowerBIRestMethod -Url $InputURL -Method Get | ConvertFrom-Json # Retrieve the workspaces $workspacesUrl = "https://api.powerbi.com/v1.0/myorg/groups" $workspacesResponse = Invoke-PowerBIRestMethod -Url $workspacesUrl -Method Get |

ConvertFrom-Json $workspaces = $workspacesResponse.value $LastRefreshdt = $ParsedResponse.value.lastRefresh.endTime $Result = $ParsedResponse.value.lastRefresh.status # Iterate over each workspace foreach ($workspace in $workspaces) { $workspaceId = $workspace.id # Retrieve datasets for the current workspace $datasetsUrl = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/datasets" $datasetsResponse = Invoke-PowerBIRestMethod -Url $datasetsUrl -Method Get | ConvertFrom-Json $datasets = $datasetsResponse.value # Iterate over each dataset in the workspace foreach ($dataset in $datasets) { $datasetId = $dataset.id $refreshScheduleUrl = "https://api.powerbi.com/v1.0/myorg/datasets/$datasetId/refreshSchedule" $refreshScheduleResponse = Invoke-PowerBIRestMethod -Url $refreshScheduleUrl -Method Get |

ConvertFrom-Json $refreshSchedule = $refreshScheduleResponse.value $days = $refreshScheduleResponse.days -join ", " $times = $refreshScheduleResponse.times -join ", " "{0}, {1}, {2}, {3}, {4}" -F $datasetId, $LastRefreshdt[$i], $Result[$i], $days, $times | Out-File -FilePath $file_path -Append -Encoding ASCII $i++ } } Using powershell, i am trying to export this code to a csv file. when i do, days and times are not showing as intended. for each dataset, if it refreshes, then in the same cell it should be like this: monday, tuesday, wednesday, etc however all days are showing in different cells.

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of