Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Out-RsCatalogItem Does Not Support TypeName of PowerBIReport #25

Closed
SQLvariant opened this issue Feb 28, 2017 · 4 comments
Closed

Out-RsCatalogItem Does Not Support TypeName of PowerBIReport #25

SQLvariant opened this issue Feb 28, 2017 · 4 comments

Comments

@SQLvariant
Copy link
Contributor

I am trying to automate deployment & testing of my Power BI reports in the RS Stand Alone Preview however Out-RsCatalogItem does not support TypeName of PowerBIReport.

PS C:\temp> 
Out-RsFolderContent -ReportServerUri http://localhost/RSSA -RsFolder /BasicSalesReport -Destination c:\temp\
Exception calling "ListChildren" with "2" argument(s): "System.Web.Services.Protocols.SoapException: The operation you are attempting on item 
'/BasicSalesReport' is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation 
you are attempting on item '/BasicSalesReport' is not allowed for this item type.
   at Microsoft.ReportingServices.Library.ReportingService2005Impl.ListChildren(String Item, Boolean Recursive, CatalogItemList& CatalogItems)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.ListChildren(String ItemPath, Boolean Recursive, CatalogItem[]& CatalogItems)"
At C:\Users\sql2k\Documents\WindowsPowerShell\Modules\ReportingServicesTools\Functions\CatalogItems\Get-RsFolderContent.ps1:82 char:9
+         $Proxy.ListChildren($RsFolder, $Recurse)
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : SoapException
 

PS C:\temp> 

I would like to be able to export this report before overwriting it with a new version.

PowerShell 5.1 using SSRS Stand Alone Preview & Power BI Desktop (SQL Server Reporting Services)

@jtarquino
Copy link
Member

The PBI reports use a different API which is not supported yet by the PowerShell modules

@rgernha rgernha self-assigned this Mar 16, 2017
@SQLvariant
Copy link
Contributor Author

Any update on this one?

@jtarquino
Copy link
Member

jtarquino commented Jun 13, 2017

GA as kept us pretty busy, however contributions to support the scenario are more than welcome

@parthsha
Copy link
Contributor

You can now use Out-RsRestCatalogItem to download Power BI Reports, Mobile Reports, Excel Workbooks and KPIs. Unfortunately, this functionality cannot be added to Out-RsCatalogItem because of API limitations. I will close this issue for now, however feel free to open it if you have any additional comments.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants