Migrating reports from SSRS

[JAFpwrBI_001]

Hi, 

We've just built a new tabular cube and now connect to a power bi dataset. We have about 200 SSRS (2012 and 2017) reports that we need to migrate from the legacy multi dim cube to the new cube (the structure is identical).

Understand these have to become Power BI paginated reports and we need to use Power BI Report Builder to do this ... most of the SSRS reports have calculations, how are these handled in PBI Rpt Builder, do they stay the same or do we need to rebuild the calcs using DAX? 

Many thanks in advance

[v-yueyunzh-msft · Accepted solution]

Hi, @JAFpwrBI_001 

To migrate your SSRS reports to Power BI paginated reports, you can use Power BI Report Builder

When you migrate your SSRS reports to paginated reports, you will need to rebuild any calculations that were in the SSRS reports using DAX. Paginated reports use DAX expressions to perform calculations, so you will need to convert any calculations that were in the SSRS reports to DAX expressions.

Secondly, my working environment does not include SSRS and Power BI Report Builder, according to the query and search, you can refer to the following documents:

Migrate multiple SSRS Reports to Power BI Paginated Reports (oliviervs.be)

Plan to migrate .rdl reports to Power BI - Power BI | Microsoft Learn

Migrate your Paginated reports to Power BI - Bing video

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly