Export not incuding all data

[Anonymous]

I have a strange situation going on.  I have a table that i have created a visual on with some filters.  The total results is 13000 (roughly).  When i export this to CSV all the rows are in the file.

However as soon as a include a value from another table only about 5300 results are in the export while the visial remans the same (13000) and all the information is shown in the visual.

One thing i did notice is when including a value from the table the ismissing data from the export the relationship between the 2 tables is a many to many.  If i include a value from a tbale with a many to one relationship the export contains all the data.

I cant figure out why all the results are in the visual but not in the export.  Any ideas?  If it is the many to many relationship how do i get around this?

[Anonymous · Accepted solution]

I cant share the data it is confidential and there are 4 table starting from 150mb upward.  To hard to cut it down and be confdent the problem will persist either.

Surely the fact that everything shows up inthe view means all the data is there as expected and just the export isnt working.  How do i work this out?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523