Data Missing - Appearing In Query Editor, Not Appearing in Report Visuals

[JF-RMT]

Hi, 

My problem i am having is that my data is somehow dissappearing after the Edit Query mode. In Query Mode i can see all my data and am confident it is there. When i click 'Close and Apply' and go to my reports i noice that certain rows of the data is missing.  

I'm sure it has nothing to do with filters, and i have even checked 'Don't Summarise' and 'Show Items With No Data', and the lines are still missing. 

I've researched a few topics and similar problems as this, dating back over two years, and cannot find a solution. 

I have a the following data-sets set up in one PBI File as follows

Data Set 1 (MPO): Amended Table from three Excel Spreadsheets. Each spreadsheet brings in only one worksheet each

Data Set 2 (TL) : Single Spreadsheet bringing in one Worksheet 

Data Set 3 (F) : Single Spreadsheet bringing in one Worksheet

Data Set 4 (INV) : Single Spreadsheet bringing in one Worksheet 

Data Set 5 (DS) : Single Spreadsheet bringing in 4 Worksheets.

Relationships:

Data Set 1 (One) to Data Sheet 5 (Many)

Data Set 1 (One) to Data Set 2 (Many)

Data Set 3 (One) to Data Set 2 (Many)

Data Set 3 (One) to Data Set 4 (Many)

Any ideas on what is causing my data to disappear? 

Thanks in advance,

James

[v-danhe-msft]

Hi @JF-RMT,

From your description,  could the sentence you post that "i noice that certain rows of the data is missing"  mean the data could not show in data view? If it is, could you please check that if you have unchecked the "Enable load":

It it stil could not solve your problem, could you please share your pbix file if possible?

Regards,

Daniel He

[JF-RMT]

Did a little further investigating, when i disabled the relationships, all of the data is now showing. 

Is there a way to have the relationships, all of the data, and filters to work from both data sets?