Updated: May 31, 2023 (February 15, 2021)

  Analyst Report

Power BI Paginated Report (RDL) Migration Tool

Andrew Snodgrass by
Andrew Snodgrass

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

RdlMigration, a free tool to help migrate SQL Server Reporting Services reports (called RDLs) to Power BI, simplifies and automates many of the manual processes required to migrate reports to the Power BI cloud service. The tool will likely interest organizations considering or performing large migrations from local servers to Power BI. It performs compatibility checks, identifies unsupported data sources or features used in reports, and converts shared datasets and resources to embedded datasets and resources, which will likely require modifying once the report is migrated. The tool also provides several options for uploading RDLs, including copying an individual report, an entire Reporting Services folder, or reports in a local folder or SharePoint Server integrated location. A summary report lists success and failure of each report and issues identified. The tool works on copies of the RDLs and does not affect the original source. It is PowerShell based, and requires registration with a Power BI tenant and security access to the destination Power BI workspace. The migration tool is available at https://github.com/microsoft/RdlMigration. The Power BI roadmap is discussed in the Microsoft 365 Roadmap at https://www.directionsonmicrosoft.com/roadmap/ref/power-bi.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now