PS C:\WINDOWS\system32> $ActivityLogsPath = "\\FTPRoot\PowerBI\ActivityLogs.csv"
>> $RetrieveDate = Get-Date
>> $ActivityLogs = Get-PowerBIActivityEvent -StartDateTime '2020-01-15T00:00:00.000' -EndDateTime '2020-01-15T23:59:59.999' | ConvertFrom-Json
>> $ActivityLogSchema = $ActivityLogs | Select-Object Id,RecordType,CreationTime,Operation,UserId,UserType,UserKey,Workload,ClientIP,UserAgent,Activity,ItemName,WorkspaceName,WorkspaceAccessList,
>> WorkspaceId,DatasetName,DatasetId,ReportName,CapacityId,CapacityName,CapacityState,CapacityUsers,AppName,ObjectId,ReportId,IsSuccess,ReportType,RequestId,
>> ActivityId,AppReportId,OrganizationId,DistributionMethod,ConsumptionMethod,DataConnectivityMode,OrgAppPermission,RefreshType,FolderDisplayName,FolderObjectId,
>> TakingOverOwner,StorageAccountName,GatewayName,GatewayType,GatewayId,DatasourceName,DatasourceId,IsUpdateAppActivity,DashboardId,ArtifactId,ArtifactName,
>> DataflowId,DataflowName,DataflowType,DataflowRefreshScheduleType,DataflowAccessTokenRequestParameters,DataflowAllowNativeQueries,CustomVisualAccessTokenResourceId,
>> CustomVisualAccessTokenSiteUri,ExportEventStartDateTimeParameter,ExportEventEndDateTimeParameter,ImportId,ImportSource,ImportType,ImportDisplayName,TemplatePackageName,
>> TemplateAppVersion,TemplateAppObjectId,TemplateAppFolderObjectId,TemplateAppOwnerTenantObjectId,AuditedArtifactInformation,ExportedArtifactInfo,
>> @{Name="RetrieveDate";Expression={$RetrieveDate}}
>>
>> $ActivityLogSchema | Export-Csv -path $ActivityLogsPath  -append -NoTypeInformation
#### Connect to Redshift parameter which works - tested with sql select statement
$env:PGCLIENTENCODING='utf-8';
psql.exe -h us-east-2.redshift.amazonaws.com  -p 5439 -U scross4565 xyz

##### Insert doesnt work
INSERT INTO PBIActivityLogs(
Id,RecordType,CreationTime,Operation,UserId,UserType,UserKey,Workload,ClientIP,UserAgent,Activity,ItemName,WorkspaceName,WorkspaceAccessList,
WorkspaceId,DatasetName,DatasetId,ReportName,CapacityId,CapacityName,CapacityState,CapacityUsers,AppName,ObjectId,ReportId,IsSuccess,ReportType,RequestId,
ActivityId,AppReportId,OrganizationId,DistributionMethod,ConsumptionMethod,DataConnectivityMode,OrgAppPermission,RefreshType,FolderDisplayName,FolderObjectId,
TakingOverOwner,StorageAccountName,GatewayName,GatewayType,GatewayId,DatasourceName,DatasourceId,IsUpdateAppActivity,DashboardId,ArtifactId,ArtifactName,
DataflowId,DataflowName,DataflowType,DataflowRefreshScheduleType,DataflowAccessTokenRequestParameters,DataflowAllowNativeQueries,CustomVisualAccessTokenResourceId,
CustomVisualAccessTokenSiteUri,ExportEventStartDateTimeParameter,ExportEventEndDateTimeParameter,ImportId,ImportSource,ImportType,ImportDisplayName,TemplatePackageName,
TemplateAppVersion,TemplateAppObjectId,TemplateAppFolderObjectId,TemplateAppOwnerTenantObjectId,AuditedArtifactInformation,ExportedArtifactInfo,RetrieveDate)
VALUES
($ActivityLogSchema.Id,$ActivityLogSchema.RecordType,$ActivityLogSchema.CreationTime,$ActivityLogSchema.Operation,$ActivityLogSchema.UserId,$ActivityLogSchema.UserType,
$ActivityLogSchema.UserKey,$ActivityLogSchema.Workload,$ActivityLogSchema.ClientIP,$ActivityLogSchema.UserAgent,$ActivityLogSchema.Activity,$ActivityLogSchema.ItemName,
$ActivityLogSchema.WorkspaceName,$ActivityLogSchema.WorkspaceAccessList,$ActivityLogSchema.WorkspaceId,$ActivityLogSchema.DatasetName,$ActivityLogSchema.DatasetId,
$ActivityLogSchema.ReportName,$ActivityLogSchema.CapacityId,$ActivityLogSchema.CapacityName,$ActivityLogSchema.CapacityState,$ActivityLogSchema.CapacityUsers,
$ActivityLogSchema.AppName,$ActivityLogSchema.ObjectId,$ActivityLogSchema.ReportId,$ActivityLogSchema.IsSuccess,$ActivityLogSchema.ReportType,$ActivityLogSchema.RequestId,
$ActivityLogSchema.ActivityId,$ActivityLogSchema.AppReportId,$ActivityLogSchema.OrganizationId,$ActivityLogSchema.DistributionMethod,$ActivityLogSchema.ConsumptionMethod,
$ActivityLogSchema.DataConnectivityMode,$ActivityLogSchema.OrgAppPermission,$ActivityLogSchema.RefreshType,$ActivityLogSchema.FolderDisplayName,$ActivityLogSchema.FolderObjectId,
$ActivityLogSchema.TakingOverOwner,$ActivityLogSchema.StorageAccountName,$ActivityLogSchema.GatewayName,$ActivityLogSchema.GatewayType,$ActivityLogSchema.GatewayId,$ActivityLogSchema.DatasourceName,
$ActivityLogSchema.DatasourceId,$ActivityLogSchema.IsUpdateAppActivity,$ActivityLogSchema.DashboardId,$ActivityLogSchema.ArtifactId,$ActivityLogSchema.ArtifactName,$ActivityLogSchema.DataflowId,
$ActivityLogSchema.DataflowName,$ActivityLogSchema.DataflowType,$ActivityLogSchema.DataflowRefreshScheduleType,$ActivityLogSchema.DataflowAccessTokenRequestParameters,
$ActivityLogSchema.DataflowAllowNativeQueries,$ActivityLogSchema.CustomVisualAccessTokenResourceId,$ActivityLogSchema.CustomVisualAccessTokenSiteUri,
$ActivityLogSchema.ExportEventStartDateTimeParameter,ActivityLogSchema.ExportEventEndDateTimeParameter,$ActivityLogSchema.ImportId,$ActivityLogSchema.ImportSource,
$ActivityLogSchema.ImportType,$ActivityLogSchema.ImportDisplayName,$ActivityLogSchema.TemplatePackageName,$ActivityLogSchema.TemplateAppVersion,
$ActivityLogSchema.TemplateAppObjectId,$ActivityLogSchema.TemplateAppFolderObjectId,$ActivityLogSchema.TemplateAppOwnerTenantObjectId,$ActivityLogSchema.AuditedArtifactInformation,
$ActivityLogSchema.ExportedArtifactInfo,$ActivityLogSchema.RetrievedDate
)
####tried this too but didnt work
LOAD DATA INFILE '\\FTPRoot\PowerBI\ActivityLogs1.csv'
INTO TABLE PBIActivityLogs
IGNORE 1 ROWS