Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I ran across an issue whereas the data extract for a table was missing records and, in turn, the extracted total did not equal the total within the visualization. After a bit of analysis, it appears that there's an issue with the extract utility when it comes to aggregating and interpreting like dimensional values. In my case, the extract dropped records when upper and lowercase like values existed.
I was able to resolve this by setting the Attribute 2 field to all uppercase within the transform settings and refreshing the data content. Consequent data extracts produced all records and the total aligned.
I would have expected the data extract to either 1. treat these all as unique rows or 2. combine the like rows regardless of case. However, a bug exists whereas the data extract is dropping records.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @TSHECKEL
May I know whether your issue is that not all the rows be displayed in your visual? If you add an index row in Power Query, will you get same issue?
Data displayed in Data View:
Data displayed in the Table visual:
If I misunderstand your problem, could you please make it more clear with some screenshots or a link of sample pbix file containing this issue? In addition, please let me know these info.
Best Regards,
Community Support Team _ Caiyun