Share via

RDL to PowerBI Migration

Prabu, Chandran 41 Reputation points
2023-05-30T15:26:29.6966667+00:00

We plan to move 300 reports from SSRS to PowerBI. We are using the import RDL option in the PowerBI service for this, and we are currently working on the estimating aspect. Sub-reports, connected reports,Multi Server Reference, KPIs with numerous charts and graphs, and multi-grouping reports are all available.

We must create classifications such as simple, medium, complex, and highly complex.

We need to know what basis we may categorize on, and please let me know which components need to be revised in PowerBI and cannot be migrated directly to PowerBI.

Thanks in Advance!!

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

SQL Server | Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. kagiyama yutaka 1,170 Reputation points
    2026-03-01T00:50:44.5433333+00:00

    I think the only real way to class RDLs is by how many server‑side bits they still lean on. subreports, shared sources, custom code, multi‑srv hops. PBI drops all of that, so just count those in Report Builder and you’ll know which ones need a full rebuild. sorry, learned that the hard way.

    0 comments
  2. Anonymous
    2023-05-31T01:19:23.54+00:00

    Hi @Prabu, Chandran

    This official document details the process of migrating .rdl reports to Power BI, maybe you can use it as a reference.

    https://learn.microsoft.com/en-us/power-bi/guidance/migrate-ssrs-reports-to-power-bi

    Best regards,

    Aniya

Your answer

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