Forum Discussion

LaurenzR's avatar
LaurenzR
Frequent Visitor
4 months ago

Paginated Report

Hello everyone,   I have a Paginated Report that works just fine on the Desktop App but if i publish the report to the powerbi Service and want to use it, i get the error message, "Unable to ren...
Paginated Report
powerbi
powerbi service
cengizhanarslan's avatar
cengizhanarslan
Super User
4 months ago

It means the DAX query generated by the Paginated Report when you select all customers exceeds what the AS engine can process as a single query.

 

Option 1) Pre-aggregate the data upstream

The complexity usually comes from the DAX query trying to resolve too many measures across too many members simultaneously. Move heavy aggregations into a dedicated table in your semantic model or into a Fabric Lakehouse/Dataflow so the Paginated Report queries pre-computed results rather than raw grain data.

 

Option 2) Review and simplify the dataset query

Open the dataset in Report Builder → dataset properties → look at the MDX or DAX query. If it uses complex nested CALCULATE, multiple FILTER iterations, or row-level expressions across a large table, simplify or split into multiple datasets.