Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
I am dealing with some minor discrepencies between reports generated in power bi and other systems. It appears that some rows (sometimes 1 out 900) are being excluded from calculations. These rows appear in the data in the front end. If I copy the table from Power BI to excel and then perform the calculations in excel everything is correct. Power BI reports the number of rows as correct in the data view and I can see the data in power BI. However, if I perform calculations such as countrows, sum or average then the result is missing the data from this one particular row.
EDIT: Also if I create a table all the data appears and the total count presented in the table is correct. But not in charts or measures.
Is there a known issue, or is there something I should be doing to my data?
I do worry as I can detect this in small data sets but this is leading me to wonder if power bi might be systematically providing the wrong results in large data sets where I can't check in such detail.
Kind regards,
Ben
Solved! Go to Solution.
Dear all,
So I found that if I delete the existing charts and create a new one the data will be correct. This seems like bug to me.
Ben
OK. Forget everything - this was totally my error as there was a page level filter I hadn't seen. Going to delete this thread.
Dear all,
So I found that if I delete the existing charts and create a new one the data will be correct. This seems like bug to me.
Ben
OK. Forget everything - this was totally my error as there was a page level filter I hadn't seen. Going to delete this thread.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |