Forum Discussion

arb1782's avatar
arb1782
Helper III
5 years ago

Help with weird table behaviour

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

Need Help

3 Replies

    • arb1782's avatar
      arb1782
      Helper III
      5 years ago

      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?

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    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.