Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
APPLIES TO: Power BI Report Builder Power BI Desktop Power BI 2022 Report Server SQL Server 2022 Reporting Services
Do you have Report Definition Language (.rdl) paginated reports in Power BI Report Server or SQL Server 2022 Reporting Services (SSRS) that you want to migrate to the Power BI service? This article provides step-by-step instructions for migrating .rdl files and Power BI reports (.pbix files) from Power BI Report Server and SQL Server 2022 Reporting Services to the Power BI service.
Note
If you're using a previous version of Reporting Services, continue to use the RDL Migration Tool for now.
You can migrate reports without downtime to your report servers or disruption to your report users. It's important to understand that you don't need to remove any data or reports. You can keep your current environment in place until you're ready for it to be retired.
You can publish and share paginated reports to your My Workspace with a Fabric free license.
To publish to other workspaces, you need to meet these prerequisites:
Read more about Power BI licenses.
You can migrate reports from SSRS instances running on-premises or on virtual machines hosted by cloud providers like Azure.
This publishing tool is designed to help customers migrate SSRS paginated reports (.rdl files) from their local servers to a Power BI workspace in their tenant. As part of the migration process, the tool also:
You can only migrate .rdl reports from your SSRS servers to Power BI. Each migrated .rdl report becomes a Power BI paginated report.
You can publish individual .rdl reports or the contents of entire folders from the SSRS web portal to the Power BI service. Read on to learn how to publish .rdl reports to Power BI.
Select Publish to find the .rdl files you want to publish from SSRS to the Power BI service.
You can also publish individual articles.
On the More info menu next to an .rdl report, select Publish.
Items that you can migrate now:
If you chose Select reports to publish, the next step is to Select reports to publish to Power BI.
After you've selected the reports you want to publish, it's time to Sign in to the Power BI service.
Now that you're signed in, select the dropdown arrow to find and Select a workspace.
In the Power BI service, navigate to the workspace where you saved the reports.
Select a report to view it in the Power BI service.
If you'd like to disable the migration setting, you need to update your report server. For more information on server properties, see the article Server Properties Advanced Page - Power BI Report Server & Reporting Services:
For sovereign clouds, you can update the Power BI endpoints by changing the site settings in the web portal.
You can migrate .rdl reports from your report servers to the Power BI service. Each migrated .rdl report becomes a Power BI paginated report.
Shared data sources and datasets aren't yet supported in the Power BI service. When you migrate .rdl reports, the RDL Migration Tool automatically converts shared datasets and data sources to embedded datasets and data sources, provided they're using supported datasets and data sources.
You can't migrate the following item types to the Power BI service:
See What paginated report features in SSRS aren't yet supported in Power BI? in the Paginated reports in Power BI FAQ for a complete list of unsupported report features.
More questions? Try asking the Reporting Services forum
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Module
Publish and share in Power BI - Training
Publish and share your Power BI reports and dashboards to teammates in your organization or to everyone on the web.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.