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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
powerbiexpert22
Impactful Individual
Impactful Individual

Report builder transformations

can i apply transformations in Report Builder same as in Power BI Desktop

1 ACCEPTED SOLUTION
jaineshp
Memorable Member
Memorable Member

@powerbiexpert22 

Report Builder has very limited transformation capabilities compared to Power BI Desktop - it only supports basic Power Query operations in preview.

Best approach: Do all your transformations in Power BI Desktop first, then connect Report Builder to the processed dataset for paginated reporting.

Report Builder is designed for formatting, not data transformation.

Fixed? ✓ Mark it • Share it • Help others!


Best Regards,
Jainesh Poojara | Power BI Developer

View solution in original post

4 REPLIES 4
v-pnaroju-msft
Community Support
Community Support

Hi powerbiexpert22,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

v-pnaroju-msft
Community Support
Community Support

Thankyou, @jaineshp@Cookistador, for your responses.

Hi powerbiexpert22,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

To the best of my understanding, Power BI Report Builder is intended for paginated report layout and rendering rather than comprehensive data shaping. It does not include the full Power Query transformation engine found in Power BI Desktop, consequently, complex transformations cannot be performed within Report Builder.

For transformation requirements, you may consider the following options:

  1. Use Power BI Dataflows in the Power BI service to prepare and transform data online using the Power Query interface. Once the dataflow is configured, connect Report Builder directly to it as a dataset source. This approach enables reuse of the same transformation logic across both Power BI Desktop and Report Builder.
  2. Perform transformations at the source level for systems such as SQL Server, Azure SQL Database, Analysis Services, etc., so that data is already in the desired shape before being consumed by Report Builder.

Please refer to the following link for further information:
Utilize Power BI Semantic Model within Power BI Re... - Microsoft Fabric Community

We hope that the information provided will help resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.

Cookistador
Super User
Super User

If you need to make some transformation on your data source, you can use Power Query like it is the case in Power BI

 

To create some measures, you cannot use DAX, but there are some alternatives in Paginated reports

  • MDX or DMX: For querying multidimensional or data mining models

  • VB.NET-style expressions: For calculated fields, formatting, and logic inside the report (like the IIf() expression you showed earlier) 

For example, this is the structure of a Sum IF in paginated report

=SUM(
IIf(
  Fields!PRODUCT_TYPE.Value = "Billable",
  Val(Fields!HTVA.Value),
  0
 )
)
But you are starting another stake which is more related to SSRS, my advise would be to create your dataset in Power BI desktop with DAX and then import the model in your paginated report
jaineshp
Memorable Member
Memorable Member

@powerbiexpert22 

Report Builder has very limited transformation capabilities compared to Power BI Desktop - it only supports basic Power Query operations in preview.

Best approach: Do all your transformations in Power BI Desktop first, then connect Report Builder to the processed dataset for paginated reporting.

Report Builder is designed for formatting, not data transformation.

Fixed? ✓ Mark it • Share it • Help others!


Best Regards,
Jainesh Poojara | Power BI Developer

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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