Forum Discussion
Missing rows in table view
Hello tarunsingla Cmcmahan
I refreshed data and checked that no filters are active in table view. In my query I added a filter to just filter the missing records. In query editor the missing rows are visible, but they are not visible in table view and therefore also missing in my report. Seems like a bug in Power BI to me. See screenshot which shows the same table in query editor and in table view. Table in table view is empty.
Regards Theo
Follow up here upon the resolution of my service ticket with MSFT. tl;dr: It was a case sensitivity issue with my merge keys.
tl: I have 2 SQL server data sources in my PBIX. In Query A (azure SQL server), my merge key is uppercase. I add a transform step there to lowercase that column.
In Query B (on-prem SQL server), my merge key *appears to be* lowercase straight from the SQL server when viewed in Power Query. And in fact, when I merge the two queries without any transformation of my merge key in Query B (because why would I? It looks like it's lowercase!), the merge appears to be successful; I can see merged columns in the Power Query view.
When I Close & Apply and add all columns from my merged dataset to a table visual, *no* column values from Query B appear in the table.
When I go back and add a lowercase transform step to Query B prior to the merge step, everything then works. The MSFT support team sent along this nice Chris Webb post on the subject as a means of explaining what I'm seeing, which is fine, but I'm not sure an end user should ever see accurate merged results in the Power Query and then *not* see them in a table view. That's just not great UX, case (in)sensitivity be damned.