Deploy SSRS Reports using PowerShell in D365 F&O
Shayan Arshi
Microsoft Dynamics AX 365 F&O | AX 2012 | PowerApps | Azure DevOps| SQL Server | Blogger | Associate Architect at Qatar Free Zone | XSystems LTD
There are two ways to deploy reports in D365 FO.
First, Directly from Visual Studio using Solution Explorer or from build menu.
Second, Deploying reports using PowerShell(Admin Mode) using below commands.
1) For deploying all SSRS reports
K:\AOSService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "K:\AosService\PackagesLocalDirectory"
2) For deploying all SSRS report in specific module
K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "K:\AosService\PackagesLocalDirectory" -Module YourModuleName
In my case I have to deploy reports of FlexProperty module.
3) For deploying specific SSRS report
K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -ReportName YourReportName.DesginTitle
In my case the command look like this
K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "K:\AosService\PackagesLocalDirectory" -ReportName AFPPRStatusReport.Report
We can also use *Purch*, This will deploy all reports that have Purch in their name.
Hope you will find this information helpful.
D365 DevOps Technical Architect
1 年JFI https://github.com/d365collaborative/d365fo.tools/blob/development/docs/Publish-D365SsrsReport.md
Data Engineer
1 年Hi, can I have your contact no. Need some info
Microsoft Dynamics Functional Consultant | MCT | Data Analysis| Power BI | SQL | Python
2 年Huggins Mafigu Tatenda Ngorima
Subject Matter Expert D365 Local Business Data On premise at Microsoft
2 年There's another way if you're using D365 FO on premise deployment type by updating SF.synclog table
Software Engineer / Technical Consultant | Microsoft Dynamics 365 F&O / AX 2012 | MS(CS) [Dec '21]
2 年Can you explain why you used "-module flexProperty" in your command?