The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am using powershell and the ReportService2010.asmx endpoint to retrieve list of SSRS Reports and their dataSources from PBI Reportserver. For background, I am calling these functions created by written by Jana Sattainathan. ( I am rather new to powershell)
I am able to pull reports, and for each report I can get a datasource REFerence. Bu now I am trying to call GetDataSourceContents so I can get the connectionString and other details. From the datasource object I have access to datasource reference and name, report path and name , But I think I need the path to the datasource itself. (Code below )
Can anyone help me figure out how to construct this value? OR, The GetDataSourceContents I am callin may not be the correct one? It does not show up in my "commands" window in the ISE , but it pops up when putting a . after the $reportproxy I am using which is https://MyServer.com/ReportServer/ReportService2010.asmx
$Reports = Get-SSRSReport -ReportServerUri $PBIRSReportServerUri -ReportFolderPath $StartFolder
foreach ($Report in $Reports){
Write-Host $Report.Name $Report.Path $Report.TypeName
$DSS = Get-SSRSReportDataSource -ReportServerUri $PBIRSReportServerUri -ReportFolderPath "/AP Administrators"
foreach ($DS in $DSS){
Write-Host $DS.ReportName $DS.ReportPath $DS.DataSourceName $DS.ReportPath $DS.ReportName
$validObject = $reportproxy.GetDataSourceContents($DS.ReportPath) <---What should this value be?
Write-Host $validObject.ConnectString -ForegroundColor Cyan
}
}
Error Message: Exception calling "GetDataSourceContents" with "1" argument(s): "The operation you are attempting on item '/AP Administrators/Server Administration/SQL Datafeed History' is not allowed for this item type
Here is a sample url to a datasource on the server , but I don't think it helps
https://MyServer/Reports/manage/catalogitem/datasources/folder/subfolder/reportname?_pk=sdp2ph00
Hi @DataRower ,
Please refer below url, hope it is helpful for you.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
7 | |
2 | |
2 | |
2 | |
2 |