Forum Discussion
Exported Underlying Data Mismatch
What i'm attempting to do is test the claim such that we can find a solution. My concern is that the method you are using to extract the data might be excluding the rows, rather than the rows not being included in the data model itself.
Yes Power BI Desktop is the developer tool, which I why i'm suggesting we start there. From what I can tell the data is inside your model and thus is part of the underlying data. However the method of exporting the data is excluding the information, which is likely related to how your report is configured.
Looking at other avenues of variables worth considering. The menu that you are selecting "Export" from, is it the correct menu for the visual containing the data you seek? Could you be hovering over another visuals menu without realising it?
Actually i realized something weird.
When i do a filter, the underlying data downloaded will be correct.
However, when i download the data without any filtering, it will exclude records with -ve value which is causing the variance of the underlying data and the actual source and report value.
I am not sure whether this is a bug of the underlying data to exclude -ve value records for default download without filter.