Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
JAFpwrBI_001
New Member

Migrating reports from SSRS

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

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

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

View solution in original post

1 REPLY 1
v-yueyunzh-msft
Community Support
Community Support

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.