Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Paginated Report is blowing up rowcount when loading. Why?

Hi,

 

I'm trying to build paginated reports whilst connecting to a small power BI dataset I have published in PBI server. The screenshot below shows me trying to generate a dimension table that is a single col with 65 rows, but for some reason whenever I run the report it claims to be loading a far greater amount of rows. Does anyone know how to solve this issue? It's making the entire process far too slow to be viable. 

 

1 Reply

  • Paginated reports just run the query you defined in dataset in your report. So this points to an issue with the query you have created. It's tricky to help further without knowing what query you are running and what your data model looks like.