12-06-2018 05:24 PM
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.
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,
12-09-2018 02:48 PM
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?
12-11-2018 12:42 AM
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?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.