cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tarkanserim Frequent Visitor
Frequent Visitor

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

Querry Editor - Appended Table.png

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

Data Tab - Appended Table.png

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. 

Data Tab - Table 2.pngData Tab - Table 1.png

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? 

7 REPLIES 7
Highlighted
AhmedOyelowo Frequent Visitor
Frequent Visitor

Re: Additional Rows Showing in Data Table, but not in Querry

I hope you applied changes to your query?

tarkanserim Frequent Visitor
Frequent Visitor

Re: Additional Rows Showing in Data Table, but not in Querry

Yup, sure did! Thank you for checking Smiley Happy 

Community Support Team
Community Support Team

Re: Additional Rows Showing in Data Table, but not in Querry

Hi @tarkanserim

 

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.

2.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tarkanserim Frequent Visitor
Frequent Visitor

Re: Additional Rows Showing in Data Table, but not in Querry

Hi Cherie,

 

I have checked the filtered row step and applied the changes, results are still the same. 

 

Here is the pbix file I am using. 

https://alphapower-my.sharepoint.com/:u:/g/personal/tarkan_serim_alpha_ca/EZ85KykGeilMl32ExD-zdLkBKB...

Community Support Team
Community Support Team

Re: Additional Rows Showing in Data Table, but not in Querry

Hi @tarkanserim

 

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

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tarkanserim Frequent Visitor
Frequent Visitor

Re: Additional Rows Showing in Data Table, but not in Querry

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. 

Community Support Team
Community Support Team

Re: Additional Rows Showing in Data Table, but not in Querry

Hi @tarkanserim

 

I cannot reproduce the same issue as you said. I would suggest you may install the latest version of Power BI Desktop.Then re-connect the database and test again. If it is not your case, you may submit a support ticket.

https://powerbi.microsoft.com/en-us/support/

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.