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
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.