Publish .rdl files to Power BI from Power BI Report Server and Reporting Services

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.

Screenshot showing Power BI Report Server Migration option.

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.

Prerequisites

Personal workspace

You can publish and share paginated reports to your My Workspace with a Fabric free license.

Other workspaces

To publish to other workspaces, you need to meet these prerequisites:

  • You have a Power BI Pro or Premium Per User license.
  • You have write access to the workspace.

Read more about Power BI licenses.

Supported versions

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:

  • Checks for unsupported data sources or report components when uploading to Power BI.
  • Saves the converted files that pass these checks to a Power BI workspace that you specify.
  • Provides a summary of the successful and unsuccessful assets migrated.

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.

Step 1: Browse to reports

Select Publish to find the .rdl files you want to publish from SSRS to the Power BI service.

Screenshot showing Publish.

  • Select Publish all reports to select all the .rdl files in the current folder and start the migration.
  • Select Select reports to publish to open a list view of all .rdl files in the current folder. Select the reports and folders you want to migrate.

You can also publish individual articles.

  • On the More info menu next to an .rdl report, select Publish.

    Screenshot showing More options to Publish.

Step 1b: Select reports

Items that you can migrate now:

  • The .rdl files
  • Linked reports (.rdl files)
  • Folders (all .rdl reports from the folder are migrated)

If you chose Select reports to publish, the next step is to Select reports to publish to Power BI.

Screenshot showing Select reports to publish to Power BI.

Step 2: Sign in/Sign up

After you've selected the reports you want to publish, it's time to Sign in to the Power BI service.

Screenshot showing Sign in to Power BI.

Step 3: Choose a workspace

Now that you're signed in, select the dropdown arrow to find and Select a workspace.

Screenshot showing selecting a workspace.

Step 4: View reports

In the Power BI service, navigate to the workspace where you saved the reports.

Screenshot showing paginated reports in Power B I service.

Select a report to view it in the Power BI service.

Site properties

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:

  • EnablePowerBIReportMigrate
  • PowerBIMigrateCountLimit
  • PowerBIMigrateUrl

For sovereign clouds, you can update the Power BI endpoints by changing the site settings in the web portal.

Limitations and considerations

You can migrate .rdl reports from your report servers to the Power BI service. Each migrated .rdl report becomes a Power BI paginated report.

Converted report features

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.

Unsupported item types

You can't migrate the following item types to the Power BI service:

  • Resources such as image files
  • KPIs
  • Mobile reports (discontinued)
  • Report models (discontinued)
  • Report parts (discontinued)

Unsupported report features

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