Forum Discussion
POWER BI is not displaying the same SQL view
I have this SQL query view below.
ID EntryDt billcodes Bill Desc amounts invhistID zassocrow invdate Housebill payamts
IS.31076722 2022-04-25 5 DEMURRAGE 311.97 IS.31076722-1 9 2022-05-09 LI1223372200 311.97
IS.31076722 2022-04-25 5 DEMURRAGE 311.97 IS.31076722-1 10 2022-05-09 LI1223372200 311.97
IS.31076722 2022-04-25 5 DEMURRAGE 623.94 IS.31076722-1 12 2022-05-09 LI1223372200 623.94
Without filtering anything in Power BI, it only displays two rows. It only displayed the 1st and 3rd row. It's missing the 2nd row, the one with a zassocrow value of 10. When I filter on the ID, the number of records right next to the check box show 3. But after I hit apply only the 1st and 3rd row showed. Clearing the cache and even shrinking my published database did not work. By design all our queries in PBI is driven by SQL views. It's been working as expected but not on the above matter. Thank you in advance for any assistance.
Hi erisant
Where did you find that the 2nd row is missing? In Power Query Editor or in Power BI Desktop?
If it's missing in Power BI Desktop after you hit Apply in Power Query Editor, please let me know whether it's missing in Data view, or in a table visual on report page? If it's missing in Date view, please check if there is any filter applying on any columns. Click on one column header and select "Clear all filters".
If it's missing in a table visual, check if you have added "zassocrow" column to the visual. A table visual will not show totally duplicated rows, which is by design. In your view data, the 1st row and 2nd row have the same value in all columns except in "zassocrow" column. So if "zassocrow" column is not in it, it will display only two rows. However, if "zassocrow" column is added, all three rows will display.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
It worked affer adding the zassocrow and setting the summarization to "Don't summarize". Thank you
Hi erisant
Where did you find that the 2nd row is missing? In Power Query Editor or in Power BI Desktop?
If it's missing in Power BI Desktop after you hit Apply in Power Query Editor, please let me know whether it's missing in Data view, or in a table visual on report page? If it's missing in Date view, please check if there is any filter applying on any columns. Click on one column header and select "Clear all filters".
If it's missing in a table visual, check if you have added "zassocrow" column to the visual. A table visual will not show totally duplicated rows, which is by design. In your view data, the 1st row and 2nd row have the same value in all columns except in "zassocrow" column. So if "zassocrow" column is not in it, it will display only two rows. However, if "zassocrow" column is added, all three rows will display.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.