Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Export to excel not working as expected

Hey experts..!! I have been trying to export the data in excel from a matrix visual. But the data that is being fetched in the excel file is not complete. Data is being skipped randomly when it is b...
Need Help
Anand24's avatar
Anand24
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,
I hope your data is not exceeding 1.5 Lakh rows. If it is so, Power BI will omit data post the first 1.5 Lakh rows from excel export even when you have a summarized export.

 

If no. of rows is the issue, the only way is to filter data and have multiple exports and then manually append into an excel.

 

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

No it is not the case Anand24 , thankyou.

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    3 years ago

    Hey Anonymous ,

     

    Just to confirm, in the article Export data from a Power BI visualization - Power BI | Microsoft Learn in the Considerations and Limitations there are a number of reasons: such as the use of more than one table or the "show items with no data"  option is enabled.

     

    That said, when exporting can you confirm that you don't have a bookmark page set or have it with slicer(s) that might be limiting it?