Help with weird table behaviour

[arb1782]

Hi

I just had a request for a data export so I made my table and realised it was cutting 5000 records from the total. I removed every single field one at a time to see whether one of them was causing it, but the number of rows was still capped. I then added a count of record ID to the end and it fixed the problem. Has anyone encountered this kind of problem before and, if so, do you what may be driving it and what I can do prevent this from happening in all my tables and visuals?

Thanks

arb

[v-alq-msft]

Hi, @arb1782 

The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000. The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000. 

For further information, please refer to the limitations and considerations in the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@arb1782 , measure having blank values can reduce rows.  blank values are not displayed by default

[arb1782]

Hi @amitchandak 

There are no measures in my table - just record ID with date, number and text fields.

I've just re-created the table in a separate PBIX with just one data source connection and this problem doesn't arise. Could it be something with the connections in my data model?