Forum Discussion
Report builder transformations
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
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
)
)