Forum Discussion
Exported Underlying Data Mismatch
The Power BI reports can only report on the underlying data in its own model, so if the data is being excluded in the underlying data, it cannot appear in the report itself. There must be another variable at play that is giving you the wrong impression either:
- The rows aren't in the data and shouldn't be there to get you the correct result.
- The rows are in the data but you haven't found them.
- The rows aren't in the data but there are other issues in the data as well that are causing you to get the correct answer for the wrong reason.
I did a filter in the report and then download the underlying data and i manage to found the missing record in the underlying data with filter.
However, when i remove the filter and download the underlying data, one of the record is missing from the underlying data file.
I am not sure how is this possible when there is no filter in in placed on the report, but the report is showing the correct value, but the underlying data is not exporting all data in this case.
One option to get the full underlying data is:
- Clicking on the Data section of Power BI using this icon:
- Right click on a table name and select "Copy Table". This will put it into your clipboard. If the data is large you will see a pop up message which needs to complete.
- Open Excel and paste into an empty sheet
If the table is too big for excel you might have troubles, but its a good first step.
I am not sure how this a solution as this is only available in the Developer version and like you mentioned, it is a tedious way of getting the data which you will not be able to get the full data at 1 glance. The objective is to give the user the correct data when they are using the PBI online.
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?