Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Additional Rows Showing in Data Table, but not in Querry

Hi Everyone,

 

I have a querry that got created by appending two tables. Looking at this appended querry in the querry editor, I see total of 25 rows as expected (for a specific item).

However, when I save this querry and start building my charts off of it, data seems to get added out of nowhere. When I look into the Data tab, and select the appended table, I see total of 38 rows (for the same specific item). 

I've also looked at the individual tables that were appended, and see that the data in there looks accurate, adding up to the expected 25 rows. 

I am currently at a loss on how to troubleshoot this further. Anyone else experienced something similar, or have thoughts on how I can go about resolving this? 

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I hope you applied changes to your query?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yup, sure did! Thank you for checking :) 

      • v-cherch-msft's avatar
        v-cherch-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous

         

        Have you checked the 'filtered rows' is the last step in 'applied steps' ? Then click 'Close&Apply'. If it is not your case, could you share the .pbix file for us to check? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

        Regards,

        Cherie