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). Howev...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yup, sure did! Thank you for checking :) 

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft 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

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

      Hi Anonymous

       

      Do the tables come from a live source (database)? Because if there are constant updates it could be consistently changing.

       

      Regards,

      Cherie

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi v-cherch-msft,

         

        Tables do come from a database. However, these tables are not being updated as it looks at historical and point in time information. I have confirmed that the data shown in the querry results in the pbix file matches the results I get when I directly querry the SQL tables for the database. 

         

        For me the odd portion is the fact that querry shows the right information, but the data shown for the charts are where the additional rows come from. These rows do not exists anywhere in the querry results or within the database at all.