Power BI Report Builder not pulling all data from Power BI dataset

[Anonymous]

Hi all, apologies if i haven't posted this is in the correct location but need some help with report builder.

I have a Power BI dataset which I have connected to in report builder. All the columns are being returned however, it's missing over 100,000 rows. I've created the same table in power bi and the correct rows are returned however, when i do the same in report builder it only returns around 30,000 rows. There are no filters/parameters etc so unsure why this is happening. There is limited information on this issue online so i was hoping i would get an answer by posting in this forum.

Thanks in advance

[Anonymous]

I have a Power BI dataset which I have connected to in report builder. All the columns are being returned however, it's missing over 100,000 rows. I've created the same table in power bi and the correct rows are returned however, when i do the same in report builder it only returns around 30,000 rows. There are no filters/parameters etc so unsure why this is happening. There is limited information on this issue online so i was hoping i would get an answer by posting in this forum.

Thanks in advance

[mhrch]

I found using a Table instead of a Matrix provided me a full dataset.

[ReportWriter]

Did anyone ever find a solution to this? I've run into a similar problem and nothing I've tried has been able to fix it. 

[mhrch]

Did you ever figure out a solution? I'm having the same issue with a report missing a significant number of rows. 

[amitchandak]

@Anonymous ,

please report an issue at : https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous]

Hi, thanks for your response however you've raised the topic in spanish in the issues forum