Share via

Creating Azure YAML pipeline to build and Deploy SSRS report on sharepoint

MADHURI GAMANE 1 Reputation point
2022-07-20T13:55:10.197+00:00

I am leaning to Create YAML Pipelines. I have Project assigned to Deploy SSRS Reports to SharePoint. Currently Our System is setup to Build and Deploy on SharePoint From TFS (using XAML) and we are converting to Git and YAML. I am successful in building and Deploying on Local Report Server from YAML, but I have to Deploy reports on SharePoint. I used the same Method as Local server just replacing the Target URL to SharePoint URL but getting No where. Any Help would be appreciated.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,957 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
40,306 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. tbgangav-MSFT 10,421 Reputation points
    2022-07-21T15:01:37.743+00:00

    Hi @MADHURI GAMANE ,

    Azure DevOps / TFS is currently not supported in this Microsoft Q&A platform. These are the products that are currently supported in this Microsoft Q&A platform. You may ask Azure DevOps / TFS related questions in this / this developer community. On the other hand, we have added sharepoint related tag to see if any sharepoint related SME's would provide any insights here.

    0 comments
  2. RaytheonXie_MSFT 36,731 Reputation points Microsoft Vendor
    2022-07-22T09:06:29.827+00:00

    Hi @MADHURI GAMANE ,
    There is no direct integration between the SharePoint Online and SSRS report.

    Microsoft’s recent introduction of Premium Per User (PPU) licensing for Power BI allows an organisation to license specific users for Power BI Premium features. This includes Power BI Paginated Reporting. Paginated Reporting in Power BI Premium allows the deployment of existing SSRS reports into a Premium Workspace for access to users with premium licenses.

    Using a trial PPU license, we tested such a deployment with some of the SSRS reports. It included a complex multi-page report designed for export and distribution as an excel document. It required some refactoring of the datasets but on the whole Paginated Reporting in Power BI allowed us to migrate existing SSRS reports. At the same time, it will help support current and future paginated reporting requirements.

    Here is a similar issue with yours
    https://sharepoint.stackexchange.com/questions/279498/how-to-deploy-ssrs-reports-to-sharepoint-online

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.