Downloadins as PDF a report from report server
Hi all, My user want to download a report from Report Server (so not power bi services) to pdf. He can't do this by downloading the pbix and then export to PDF because the report use live connection and my user does'nt have access to datas. I'd like to do this using a PowerShell script, but I am not allowed by my organisation to download MicrosoftPowerBIMgmt PowerShell module. I tested several PowerShell scripts found on the net without sucess. Any idea how to achieve that ? hank you in advance for your help. Regards, Alice
Using Powershell and ReportService2010.asmx to get datasource details how to find ds path
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
Update Shared Datasouce for Report using PowerShell
Hello, We are in the process of migrating from SSRS to PBI-RS and have been testing reports in DEV using DEV Datasources. We have over 300 reports, that we need to switch to Production Datasources, and I've been looking for a way to do it via powershell.. As a NOOB, I'm running into issues. I downloaded the ReportingServicesTools and it looked like it would be pretty simple... NOPE... I found that I should be using the Get-RSITEMDatasource and Set-RSITEMDatasource based on my reading.. so I Ran the following: PS C:\> $dataSources = Get-RsItemDataSource -ReportServerUri 'http://powerbi.dev.sql.odnss.com/Reportserver/' -RsItem '/docket/All Timekeepers' Ran Succesfully Then I ran PS C:\> Set-RsItemDataSource -DataSource $datasources -RsItem '/AR/AR Aging' -ReportServerUri 'http://powerbi.dev.sql.odnss.com/reportserver/' I get the error below Please use Set-RsDataSource to update shared data sources! At C:\Program Files\WindowsPowerShell\Modules\ReportingServicesTools\0.0.5.0\Functions\CatalogItems\Set-RsItemDataSource.ps1:143 char:17 + ... throw "Please use Set-RsDataSource to update shared data ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (Please use Set-...d data sources!:String) [], RuntimeException + FullyQualifiedErrorId : Please use Set-RsDataSource to update shared data sources! I'm not trying to update the Shared Datasource itself... I'm simply tying to update the report to use another Shared Datasouce.. What am I doing wrong?Azure partition refresh issue
Hi all, I am refreshing ds partitions via Azur runbooks and powershell scripts. This week I noticed that the error below appears (previously everything worked fine) This is the line that its calling: $Srv.Connect($connectionString) And the connection string: $connectionString ="Provider=MSOLAP;Data Source=$XmlaEndpoint;User ID=app:$PowerBIServiceApplicationID;Password=$PowerBIServiceApplicationKey;Persist Security Info=True;Impersonation Level=Impersonate" Do you have any suggestions why suddenly this script stoped working a week ago? Thanks in advance!
